APPS.AR_CMGT_AGING dependencies on AR_CMGT_CURR_USAGE_GT

Line 252: from ar_cmgt_curr_usage_gt)))

248: and p_source = 'CONS_BILL')
249: or (nvl(p_source,'x') <> 'CONS_BILL' and
250: ps.invoice_currency_code in
251: (select currency
252: from ar_cmgt_curr_usage_gt)))
253: ) ;
254: CURSOR c_buckets2 IS
255: select sum(adr), sum(bucket0), sum(bucket1), sum(bucket2),
256: sum(bucket3), sum(bucket4), sum(bucket5),sum(bucket6)

Line 395: from ar_cmgt_curr_usage_gt)))

391: and p_source = 'CONS_BILL')
392: or (nvl(p_source,'x') <> 'CONS_BILL' and
393: ps.invoice_currency_code in
394: (select currency
395: from ar_cmgt_curr_usage_gt)))
396: ) ;
397: CURSOR c_buckets3 IS
398: select sum(adr), sum(bucket0), sum(bucket1), sum(bucket2),
399: sum(bucket3), sum(bucket4), sum(bucket5),sum(bucket6)

Line 519: from ar_cmgt_curr_usage_gt)))

515: and p_source = 'CONS_BILL')
516: or (nvl(p_source,'x') <> 'CONS_BILL' and
517: ps.invoice_currency_code in
518: (select currency
519: from ar_cmgt_curr_usage_gt)))
520: ) ;
521: CURSOR c_buckets4 IS
522: select sum(adr), sum(bucket0), sum(bucket1), sum(bucket2),
523: sum(bucket3), sum(bucket4), sum(bucket5),sum(bucket6)

Line 662: from ar_cmgt_curr_usage_gt)))

658: and p_source = 'CONS_BILL')
659: or (nvl(p_source,'x') <> 'CONS_BILL' and
660: ps.invoice_currency_code in
661: (select currency
662: from ar_cmgt_curr_usage_gt)))
663: ) ;
664: BEGIN
665:
666: -- Put in the currencies in the global temporary table

Line 689: INSERT INTO ar_cmgt_curr_usage_gt ( credit_request_id, currency) values

685: IF ( (nvl(l_include_all_flag,'N') = 'N') and l_limit_currency IS NOT NULL )
686: THEN
687: for i in 1..l_curr_tbl.COUNT
688: LOOP
689: INSERT INTO ar_cmgt_curr_usage_gt ( credit_request_id, currency) values
690: ( NULL, l_curr_tbl(i).usage_curr_code);
691: END LOOP;
692: ELSE
693: -- populate temp table with all currency. may not be a good soulution

Line 695: INSERT INTO ar_cmgt_curr_usage_gt(currency)

691: END LOOP;
692: ELSE
693: -- populate temp table with all currency. may not be a good soulution
694: -- to take this approach. Would be better to have another cursor.
695: INSERT INTO ar_cmgt_curr_usage_gt(currency)
696: ( select distinct currency from ar_trx_bal_summary);
697: END IF; */
698: INSERT INTO ar_cmgt_curr_usage_gt(currency)
699: ( select distinct currency from ar_trx_bal_summary);

Line 698: INSERT INTO ar_cmgt_curr_usage_gt(currency)

694: -- to take this approach. Would be better to have another cursor.
695: INSERT INTO ar_cmgt_curr_usage_gt(currency)
696: ( select distinct currency from ar_trx_bal_summary);
697: END IF; */
698: INSERT INTO ar_cmgt_curr_usage_gt(currency)
699: ( select distinct currency from ar_trx_bal_summary);
700: END IF;
701:
702: --