apzl_leasing/src_sql/function/getCustomerName.sql

create function getCustomerName(pCustomerID varchar(40)) returns varchar(80)
RETURN (SELECT CustomerName FROM customer_info WHERE customerid = pCustomerID);