[Home] [Help]
2052: BEGIN
2053: IF (p_cust_or_vend = 'C') THEN
2054: SELECT hzca.customer_class_code
2055: INTO l_vendor_type
2056: FROM hz_cust_accounts hzca
2057: WHERE hzca.cust_account_id = p_cust_vend_id;
2058: ELSIF (p_cust_or_vend = 'V') THEN
2059: SELECT vendor_type_lookup_code
2060: INTO l_vendor_type