DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on HZ_CUSTOMER_PROFILES

Line 21: FROM HZ_CUSTOMER_PROFILES

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

Line 1619: FROM HZ_CUSTOMER_PROFILES

1615: --l_related_cust_cursor t_cursor;
1616: --
1617: CURSOR l_acct_type_cursor (cust_id_in number) is
1618: SELECT distinct profile_class_id
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