APPS.IEX_ASSIGN_COLL_LEVEL_PVT dependencies on IEX_DELINQUENCIES

Line 40: select party_cust_id from iex_delinquencies

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;
42:
43: Cursor C_get_objCode(p_id number) is
44: select shs.score_object_code from iex_score_histories shs where shs.score_history_id = (select max(score_history_id)