APPS.QP_SOURCING_API_PUB dependencies on HZ_CUST_ACCT_RELATE

Line 25: FROM HZ_CUST_ACCT_RELATE

21: FROM HZ_CUSTOMER_PROFILES
22: WHERE cust_account_id = cust_id_in;
23: CURSOR l_related_cust_cursor(cust_id_in number) is
24: SELECT RELATED_CUST_ACCOUNT_ID
25: FROM HZ_CUST_ACCT_RELATE
26: WHERE cust_account_id = cust_id_in;
27:
28: NUMERIC_OVERFLOW EXCEPTION;
29: NUMERIC_OR_VALUE EXCEPTION;

Line 1623: FROM HZ_CUST_ACCT_RELATE

1619: FROM HZ_CUSTOMER_PROFILES
1620: WHERE cust_account_id = cust_id_in;
1621: CURSOR l_related_cust_cursor(cust_id_in number) is
1622: SELECT RELATED_CUST_ACCOUNT_ID
1623: FROM HZ_CUST_ACCT_RELATE
1624: WHERE cust_account_id = cust_id_in;
1625:
1626: BEGIN
1627: g_customer_info:=G_Customer_Info_null;