APPS.JAI_PA_BILLING_PKG dependencies on FND_CURRENCIES

Line 66: cursor gc_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type)

62: from jai_pa_draft_invoices
63: where project_id = cp_project_id
64: and draft_invoice_num = cp_draft_invoice_num;
65:
66: cursor gc_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type)
67: is
68: select precision
69: from fnd_currencies
70: where currency_code = cp_currency_code;

Line 69: from fnd_currencies

65:
66: cursor gc_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type)
67: is
68: select precision
69: from fnd_currencies
70: where currency_code = cp_currency_code;
71:
72:
73: function get_spec_version return varchar2

Line 1566: ln_precision fnd_currencies.precision%type;

1562: ln_tax_amt number;
1563: ln_func_tax_amt number;
1564: ln_cum_tax_amt number;
1565: lv_modvat_flag ja_in_ap_tax_distributions.recoverable_flag%type;
1566: ln_precision fnd_currencies.precision%type;
1567: is_upd_pay_sch_success boolean;
1568: lv_account_name jai_rgm_regns.attribute_code%type;
1569: ln_tax_variance_inv_cur number;
1570: ln_user_id fnd_user.user_id%type := fnd_global.user_id;

Line 2116: ln_precision fnd_currencies.precision%type;

2112: v_tax_installment number;
2113: v_payment_num ap_payment_schedules_all.payment_num%type;
2114: v_total_payment_amt number;
2115: v_diff_tax_amount number;
2116: ln_precision fnd_currencies.precision%type;
2117:
2118:
2119: cursor c_total_payment_amt is
2120: select sum(gross_amount)