[Home] [Help]
1364: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
1365: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1366: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1367: INTO l_credit_limit
1368: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
1369: ar_cmgt_setup_options cm_opt
1370: WHERE prof.party_id = p_party_id
1371: AND prof.site_use_id IS NULL
1372: AND prof.status = 'A'
1383: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
1384: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1385: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1386: INTO l_credit_limit
1387: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
1388: ar_cmgt_setup_options cm_opt
1389: WHERE prof.cust_account_id = p_cust_account_id
1390: AND prof.site_use_id IS NULL
1391: AND prof.status = 'A'
1398: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
1399: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1400: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1401: INTO l_credit_limit
1402: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
1403: ar_cmgt_setup_options cm_opt
1404: WHERE prof.site_use_id = p_customer_site_use_id
1405: AND prof.status = 'A'
1406: AND prof.cust_account_profile_id = prof_amt.cust_account_profile_id