APPS.IEX_COLL_IND_PUB dependencies on HZ_CUSTOMER_PROFILES

Line 48: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,

44: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL,
45: gl_currency_api.convert_amount_sql(prof_amt.currency_code,g_base_currency_code,
46: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
47: INTO l_credit_limit
48: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
49: ar_cmgt_setup_options cm_opt
50: WHERE prof.party_id = p_party_id
51: AND prof.site_use_id IS NULL
52: AND prof.status = 'A'

Line 63: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,

59: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL,
60: gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_base_currency_code,
61: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
62: INTO l_credit_limit
63: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
64: ar_cmgt_setup_options cm_opt
65: WHERE prof.cust_account_id = p_cust_account_id
66: AND prof.site_use_id IS NULL
67: AND prof.status = 'A'

Line 76: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,

72: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL,
73: gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_base_currency_code,
74: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
75: INTO l_credit_limit
76: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
77: ar_cmgt_setup_options cm_opt
78: WHERE prof.site_use_id = p_customer_site_use_id
79: AND prof.status = 'A'
80: AND prof.cust_account_profile_id = prof_amt.cust_account_profile_id