APPS.IEX_PROFILE dependencies on AR_COLLECTORS

Line 391: FROM hz_customer_profiles cust_prof, ar_collectors coll

387: CURSOR PARTY_CUSTOMER_PROFILE_CUR(p_party_id NUMBER)
388: IS
389: SELECT coll.name,
390: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
391: FROM hz_customer_profiles cust_prof, ar_collectors coll
392: WHERE cust_prof.party_id = p_party_id
393: AND coll.collector_id(+) = cust_prof.collector_id
394: AND cust_prof.cust_account_id = -1;
395:

Line 400: FROM hz_customer_profiles cust_prof, ar_collectors coll

396: CURSOR CUST_CUSTOMER_PROFILE_CUR(p_cust_account_id NUMBER)
397: IS
398: SELECT coll.name,
399: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
400: FROM hz_customer_profiles cust_prof, ar_collectors coll
401: WHERE cust_prof.cust_account_id = p_cust_account_id
402: AND coll.collector_id(+) = cust_prof.collector_id
403: AND cust_prof.site_use_id IS NULL;
404:

Line 409: FROM hz_customer_profiles cust_prof, ar_collectors coll

405: CURSOR SITE_CUSTOMER_PROFILE_CUR(p_customer_site_use_id NUMBER)
406: IS
407: SELECT coll.name,
408: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
409: FROM hz_customer_profiles cust_prof, ar_collectors coll
410: WHERE cust_prof.site_use_id = p_customer_site_use_id
411: AND coll.collector_id(+) = cust_prof.collector_id;
412:
413: CURSOR C_DEL(p_delinquency_id NUMBER)