APPS.IEX_COLL_IND_PUB dependencies on AR_CMGT_SETUP_OPTIONS

Line 49: ar_cmgt_setup_options cm_opt

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'
53: AND prof.cust_account_profile_id = prof_amt.cust_account_profile_id

Line 64: ar_cmgt_setup_options cm_opt

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'
68: AND prof.cust_account_profile_id = prof_amt.cust_account_profile_id

Line 77: ar_cmgt_setup_options cm_opt

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
81: AND prof_amt.site_use_id = p_customer_site_use_id;