DBA Data[Home] [Help]

APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on FND_CURRENCIES

Line 3544: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is

3540: from dual;
3541:
3542: -- start addition by ssumaith -bug# 3127834
3543:
3544: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
3545: select precision
3546: from fnd_currencies
3547: where currency_code = cp_currency_code;
3548:

Line 3546: from fnd_currencies

3542: -- start addition by ssumaith -bug# 3127834
3543:
3544: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
3545: select precision
3546: from fnd_currencies
3547: where currency_code = cp_currency_code;
3548:
3549: -- ends here additions by ssumaith -bug# 3127834
3550: --Added by kunkumar for porting 4454499

Line 3566: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834

3562: where invoice_id = p_inv_id;
3563:
3564: ln_source VARCHAR2(50);
3565:
3566: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
3567: ln_tax_precision jai_cmn_taxes_all.rounding_factor%type;
3568: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;
3569: r_tax_lines_rec r_tax_lines_cur%ROWTYPE;
3570: /* r_cur_items_rec r_cur_items%ROWTYPE; Bug#4095234*/

Line 5636: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is

5632: cursor c_get_invoice_distribution is -- bug#3332988
5633: select ap_invoice_distributions_s.nextval
5634: from dual;
5635:
5636: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
5637: select precision
5638: from fnd_currencies
5639: where currency_code = cp_currency_code;
5640:

Line 5638: from fnd_currencies

5634: from dual;
5635:
5636: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
5637: select precision
5638: from fnd_currencies
5639: where currency_code = cp_currency_code;
5640:
5641: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)
5642: is

Line 5648: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834

5644: ,ship_to_location_id
5645: from po_line_locations_all plla
5646: where plla.line_location_id = cpn_line_location_id;
5647:
5648: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
5649: v_statement_no VARCHAR2(6);
5650: v_dist_reversal_cnt NUMBER;
5651: v_batch_id NUMBER;
5652: c_tax_rec c_tax%ROWTYPE;