APPS.FUN_NET_ARAP_PKG dependencies on FND_CURRENCIES

Line 668: l_inv_from_clause := l_inv_from_clause || ', fnd_currencies fc ';

664: :exchange_rate_type,
665: SUM(aps.amount_remaining)) AS open_amount,
666: min(aps.payment_num),
667: max(aps.payment_num) ';
668: l_inv_from_clause := l_inv_from_clause || ', fnd_currencies fc ';
669: l_inv_where_clause := l_inv_where_clause || ' AND api.invoice_currency_code = fc.currency_code ';
670:
671: l_inv_group_by_clause := ' GROUP BY api.invoice_id,
672: api.invoice_amount,

Line 790: TYPE precision_tab IS TABLE OF fnd_currencies.precision%TYPE INDEX BY BINARY_INTEGER;

786: TYPE trx_type IS TABLE OF fun_net_ar_txns_all.customer_trx_id%TYPE INDEX BY BINARY_INTEGER;
787: TYPE payment_num IS TABLE OF ap_payment_schedules_all.payment_num%TYPE INDEX BY BINARY_INTEGER;
788: TYPE inv_rank IS TABLE OF fun_net_ap_invs_all.ap_txn_rank%TYPE INDEX BY BINARY_INTEGER;
789: TYPE exchange_rate IS TABLE OF ap_invoices_all.exchange_rate%TYPE INDEX BY BINARY_INTEGER;
790: TYPE precision_tab IS TABLE OF fnd_currencies.precision%TYPE INDEX BY BINARY_INTEGER;
791: --l_invoice_id fun_net_ap_invs_all.invoice_id%TYPE;
792: --l_invoice_amt fun_net_ap_invs_all.invoice_amt%TYPE;
793: --l_open_amt fun_net_ap_invs_all.open_amt%TYPE;
794: --l_inv_curr_open_amt fun_net_ap_invs_all.inv_curr_open_amt%TYPE;

Line 1492: l_inv_currency fnd_currencies.currency_code%TYPE;

1488: l_trx_id trx_type;
1489: l_inv_curr_open_amt amt_type;
1490: l_inv_curr_net_amt amt_type;
1491: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;
1492: l_inv_currency fnd_currencies.currency_code%TYPE;
1493: l_precision fnd_currencies.precision%TYPE;
1494:
1495: TYPE tnxCurTyp IS REF CURSOR;
1496: tnx_rec tnxCurTyp;

Line 1493: l_precision fnd_currencies.precision%TYPE;

1489: l_inv_curr_open_amt amt_type;
1490: l_inv_curr_net_amt amt_type;
1491: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;
1492: l_inv_currency fnd_currencies.currency_code%TYPE;
1493: l_precision fnd_currencies.precision%TYPE;
1494:
1495: TYPE tnxCurTyp IS REF CURSOR;
1496: tnx_rec tnxCurTyp;
1497:

Line 1531: FROM ap_invoices_all api, fnd_currencies fc

1527:
1528:
1529: SELECT fc.currency_code,fc.precision
1530: INTO l_inv_currency,l_precision
1531: FROM ap_invoices_all api, fnd_currencies fc
1532: WHERE api.invoice_id = l_trx_id(i)
1533: AND api.invoice_currency_code = fc.currency_code;
1534:
1535: l_exc_rate := Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);

Line 1547: FROM ra_customer_trx_all rct, fnd_currencies fc

1543: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);
1544: ELSIF p_appln = 'AR' THEN
1545: SELECT fc.currency_code,fc.precision
1546: INTO l_inv_currency,l_precision
1547: FROM ra_customer_trx_all rct, fnd_currencies fc
1548: WHERE rct.customer_trx_id = l_trx_id(i)
1549: AND rct.invoice_currency_code = fc.currency_code;
1550:
1551: l_inv_curr_net_amt(i) := l_amt_to_net * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);

Line 2589: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;

2585: l_gl_date date; -- Bug: 7639863
2586:
2587: TYPE vendor_type IS TABLE OF po_vendors.vendor_id%TYPE INDEX BY BINARY_INTEGER;
2588: TYPE vendor_site_type IS TABLE OF po_vendor_sites_all.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
2589: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;
2590: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;
2591: TYPE ap_invoice_type IS TABLE OF ap_invoices.invoice_id%TYPE INDEX BY BINARY_INTEGER;
2592: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;
2593: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;

Line 3455: FROM fnd_currencies fc

3451:
3452:
3453: SELECT fc.precision
3454: INTO l_precision
3455: FROM fnd_currencies fc
3456: WHERE fc.currency_code = txnTable(i).invoice_currency_code;
3457:
3458: fun_net_util.Log_String(g_event_level,l_path
3459: ,'l_precision:' ||l_precision);