DBA Data[Home] [Help]

APPS.IEX_COLL_IND_PUB dependencies on GL_CURRENCY_API

Line 45: gl_currency_api.convert_amount_sql(prof_amt.currency_code,g_base_currency_code,

41: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - p_org_id = ' ||p_org_id);
42:
43: IF p_party_id IS NOT NULL THEN
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

Line 60: gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_base_currency_code,

56: AND prof_amt.site_use_id IS NULL;
57:
58: ELSIF p_cust_account_id IS NOT NULL THEN
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

Line 73: gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_base_currency_code,

69: AND prof_amt.cust_account_id = p_cust_account_id
70: AND prof_amt.site_use_id IS NULL;
71: ELSIF p_customer_site_use_id IS NOT NULL THEN
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