APPS.IEX_COLL_IND dependencies on HZ_CUSTOMER_PROFILES

Line 1482: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

1478: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1479: -- sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1480: sysdate, l_conversion_type, prof_amt.overall_credit_limit)))
1481: INTO l_credit_limit
1482: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt
1483: -- ar_cmgt_setup_options cm_opt
1484: WHERE prof.party_id = p_party_id
1485: AND prof.site_use_id IS NULL
1486: AND prof.status = 'A'

Line 1502: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

1498: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1499: -- sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1500: sysdate, l_conversion_type, prof_amt.overall_credit_limit)))
1501: INTO l_credit_limit
1502: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt
1503: -- ar_cmgt_setup_options cm_opt
1504: WHERE prof.cust_account_id = p_cust_account_id
1505: AND prof.site_use_id IS NULL
1506: AND prof.status = 'A'

Line 1518: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

1514: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1515: -- sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1516: sysdate, l_conversion_type, prof_amt.overall_credit_limit)))
1517: INTO l_credit_limit
1518: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt
1519: -- ar_cmgt_setup_options cm_opt
1520: WHERE prof.site_use_id = p_customer_site_use_id
1521: AND prof.status = 'A'
1522: AND prof.cust_account_profile_id = prof_amt.cust_account_profile_id