create function GETBUSINESSNAME(pTypeNo varchar(40)) returns varchar(80)
RETURN (SELECT TypeName FROM BUSINESS_TYPE
WHERE TypeNo= pTypeNo);