APPS.JAI_AR_MATCH_TAX_PKG dependencies on FND_CURRENCIES

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

1274: WHERE customer_trx_id = cp_customer_trx_id
1275: AND account_class = 'REC'
1276: AND latest_rec_flag = 'Y';
1277:
1278: --get the currency precision from fnd_currencies for the set_of_books_id
1279: CURSOR cur_curr_precision(cp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE)
1280: IS
1281: SELECT NVL(minimum_accountable_unit,NVL(precision,2))
1282: FROM fnd_currencies

Line 1282: FROM fnd_currencies

1278: --get the currency precision from fnd_currencies for the set_of_books_id
1279: CURSOR cur_curr_precision(cp_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE)
1280: IS
1281: SELECT NVL(minimum_accountable_unit,NVL(precision,2))
1282: FROM fnd_currencies
1283: WHERE currency_code IN
1284: (
1285: SELECT Currency_code
1286: FROM gl_sets_of_books

Line 1470: ln_precision fnd_currencies.precision%TYPE;

1466: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
1467: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;
1468: lv_amount_includes_tax_flag ar_vat_tax_all.amount_includes_tax_flag%TYPE;
1469: lv_account_Set_flag ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE;
1470: ln_precision fnd_currencies.precision%TYPE;
1471: ln_accounting_rule_id NUMBER;
1472: ln_old_amount NUMBER;
1473: ln_taxable_amount NUMBER;
1474: ln_tax_amt NUMBER;

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

1557: FETCH cur_min_payment_schedule INTO rec_min_payment_schedule;
1558: CLOSE cur_min_payment_schedule;
1559:
1560:
1561: --get the currency precision from fnd_currencies for the set_of_books_id
1562: OPEN cur_curr_precision(rec_customer_trx.set_of_books_id);
1563: FETCH cur_curr_precision INTO ln_precision;
1564: CLOSE cur_curr_precision;
1565: