20: FROM HZ_CUSTOMER_PROFILES
21: WHERE cust_account_id = cust_id_in;
22: CURSOR l_related_cust_cursor(cust_id_in number) is
23: SELECT RELATED_CUST_ACCOUNT_ID
24: FROM HZ_CUST_ACCT_RELATE
25: WHERE cust_account_id = cust_id_in;
26:
27: NUMERIC_OVERFLOW EXCEPTION;
28: NUMERIC_OR_VALUE EXCEPTION;
1627: FROM HZ_CUSTOMER_PROFILES
1628: WHERE cust_account_id = cust_id_in;
1629: CURSOR l_related_cust_cursor(cust_id_in number) is
1630: SELECT RELATED_CUST_ACCOUNT_ID
1631: FROM HZ_CUST_ACCT_RELATE
1632: WHERE cust_account_id = cust_id_in;
1633:
1634: BEGIN
1635: