APPS.IEX_PROFILE dependencies on AR_COLLECTORS

Line 463: FROM hz_customer_profiles cust_prof, ar_collectors coll

459: CURSOR PARTY_CUSTOMER_PROFILE_CUR(p_party_id NUMBER)
460: IS
461: SELECT coll.name,
462: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
463: FROM hz_customer_profiles cust_prof, ar_collectors coll
464: WHERE cust_prof.party_id = p_party_id
465: AND coll.collector_id(+) = cust_prof.collector_id
466: AND cust_prof.cust_account_id = -1;
467:

Line 472: FROM hz_customer_profiles cust_prof, ar_collectors coll

468: CURSOR CUST_CUSTOMER_PROFILE_CUR(p_cust_account_id NUMBER)
469: IS
470: SELECT coll.name,
471: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
472: FROM hz_customer_profiles cust_prof, ar_collectors coll
473: WHERE cust_prof.cust_account_id = p_cust_account_id
474: AND coll.collector_id(+) = cust_prof.collector_id
475: AND cust_prof.site_use_id IS NULL;
476:

Line 481: FROM hz_customer_profiles cust_prof, ar_collectors coll

477: CURSOR SITE_CUSTOMER_PROFILE_CUR(p_customer_site_use_id NUMBER)
478: IS
479: SELECT coll.name,
480: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
481: FROM hz_customer_profiles cust_prof, ar_collectors coll
482: WHERE cust_prof.site_use_id = p_customer_site_use_id
483: AND coll.collector_id(+) = cust_prof.collector_id;
484:
485: CURSOR C_DEL(p_delinquency_id NUMBER)