APPS.IEX_ASSIGN_COLL_LEVEL_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 37: (select cust_acct_site_id from hz_cust_site_uses_all where site_use_code = 'BILL_TO' and site_use_id = id));

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
40: select party_cust_id from iex_delinquencies
41: where delinquency_id = id;