APPS.IEX_ASSIGN_COLL_LEVEL_PVT dependencies on HZ_CUST_ACCOUNTS

Line 30: select party_id from hz_cust_accounts

26: and ish.score_object_code = p_code; --<> 'IEX_INVOICES';
27:
28:
29: Cursor C_get_PartyId_Account(id number) is
30: select party_id from hz_cust_accounts
31: where cust_account_id = id;
32:
33:
34: Cursor C_get_PartyId_BillTo(id number) is

Line 35: select party_id from hz_cust_accounts where cust_account_id =

31: where cust_account_id = id;
32:
33:
34: Cursor C_get_PartyId_BillTo(id number) is
35: select party_id from hz_cust_accounts where cust_account_id =
36: (select cust_account_id from hz_cust_acct_sites_all where cust_acct_site_id =
37: (select cust_acct_site_id from hz_cust_site_uses_all where site_use_code = 'BILL_TO' and site_use_id = id));
38:
39: Cursor C_get_PartyId_Del(id number) is