DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on HZ_CUSTOMER_PROFILES

Line 20: FROM HZ_CUSTOMER_PROFILES

16: --l_related_cust_cursor t_cursor;
17: --
18: CURSOR l_acct_type_cursor (cust_id_in number) is
19: SELECT distinct profile_class_id
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

Line 1627: FROM HZ_CUSTOMER_PROFILES

1623: --l_related_cust_cursor t_cursor;
1624: --
1625: CURSOR l_acct_type_cursor (cust_id_in number) is
1626: SELECT distinct profile_class_id
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