APPS.IEX_COLL_IND dependencies on AR_CMGT_SETUP_OPTIONS

Line 1369: ar_cmgt_setup_options cm_opt

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

Line 1388: ar_cmgt_setup_options cm_opt

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

Line 1403: ar_cmgt_setup_options cm_opt

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

Line 1438: ar_cmgt_setup_options cm_opt,

1434: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1435: sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1436: INTO l_high_credit_ytd
1437: FROM ar_trx_summary trx_summ,
1438: ar_cmgt_setup_options cm_opt,
1439: hz_cust_accounts ca
1440: WHERE NVL(trx_summ.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,
1441: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
1442: = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

Line 1450: ar_cmgt_setup_options cm_opt

1446: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1447: sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1448: INTO l_high_credit_ytd
1449: FROM ar_trx_summary trx_summ,
1450: ar_cmgt_setup_options cm_opt
1451: WHERE NVL(trx_summ.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,
1452: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
1453: = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
1454: AND trx_summ.cust_account_id = p_cust_account_id;

Line 1460: ar_cmgt_setup_options cm_opt

1456: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1457: sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1458: INTO l_high_credit_ytd
1459: FROM ar_trx_summary trx_summ,
1460: ar_cmgt_setup_options cm_opt
1461: WHERE NVL(trx_summ.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,
1462: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
1463: = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
1464: AND trx_summ.site_use_id = p_customer_site_use_id;