APPS.JAI_AR_MATCH_TAX_PKG dependencies on FND_CURRENCIES

Line 1900: --get the currency precision from fnd_currencies for the set_of_books_id

1896: AND account_class = 'REV' --Modified by Xiao for POT change, reg bug#12533434
1897: AND customer_trx_line_id = cp_customer_trx_line_id; --Modified by Xiao for POT change, reg bug#12533434
1898: -- Added by Chong.Lei for POT code port end
1899:
1900: --get the currency precision from fnd_currencies for the set_of_books_id
1901: CURSOR cur_curr_precision(cp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE)
1902: IS
1903: SELECT NVL(minimum_accountable_unit,NVL(precision,2))
1904: FROM fnd_currencies

Line 1904: FROM fnd_currencies

1900: --get the currency precision from fnd_currencies for the set_of_books_id
1901: CURSOR cur_curr_precision(cp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE)
1902: IS
1903: SELECT NVL(minimum_accountable_unit,NVL(precision,2))
1904: FROM fnd_currencies
1905: WHERE currency_code IN
1906: (
1907: SELECT Currency_code
1908: FROM gl_sets_of_books

Line 2151: ln_precision fnd_currencies.precision%TYPE;

2147: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
2148: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;
2149: lv_amount_includes_tax_flag ar_vat_tax_all.amount_includes_tax_flag%TYPE;
2150: lv_account_Set_flag ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE;
2151: ln_precision fnd_currencies.precision%TYPE;
2152: ln_accounting_rule_id NUMBER;
2153: ln_old_amount NUMBER;
2154: ln_taxable_amount NUMBER;
2155: ln_tax_amt NUMBER;

Line 2248: --get the currency precision from fnd_currencies for the set_of_books_id

2244: FETCH cur_min_payment_schedule INTO rec_min_payment_schedule;
2245: CLOSE cur_min_payment_schedule;
2246:
2247:
2248: --get the currency precision from fnd_currencies for the set_of_books_id
2249: OPEN cur_curr_precision(rec_customer_trx.set_of_books_id);
2250: FETCH cur_curr_precision INTO ln_precision;
2251: CLOSE cur_curr_precision;
2252:

Line 3501: ln_precision fnd_currencies.precision%TYPE;

3497: ln_exchange_rate jai_ar_trxs.exchange_rate%type;
3498: lv_account_class_tax VARCHAR2(10) := 'TAX';
3499: lv_account_class_freight VARCHAR2(10) := 'FREIGHT';
3500: lv_account_class_rec VARCHAR2(10) := 'REC';
3501: ln_precision fnd_currencies.precision%TYPE;
3502: ln_old_amount NUMBER;
3503: ln_taxable_amount NUMBER;
3504: ln_tax_amt NUMBER;
3505: ln_tax_acctd_amount NUMBER;