DBA Data[Home] [Help]

APPS.JAI_PA_BILLING_PKG dependencies on FND_CURRENCIES

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

49: from jai_pa_draft_invoices
50: where project_id = cp_project_id
51: and draft_invoice_num = cp_draft_invoice_num;
52:
53: cursor gc_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type)
54: is
55: select precision
56: from fnd_currencies
57: where currency_code = cp_currency_code;

Line 56: from fnd_currencies

52:
53: cursor gc_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type)
54: is
55: select precision
56: from fnd_currencies
57: where currency_code = cp_currency_code;
58:
59:
60: function get_spec_version return varchar2

Line 1530: ln_precision fnd_currencies.precision%type;

1526: ln_tax_amt number;
1527: ln_func_tax_amt number;
1528: ln_cum_tax_amt number;
1529: lv_modvat_flag ja_in_ap_tax_distributions.recoverable_flag%type;
1530: ln_precision fnd_currencies.precision%type;
1531: is_upd_pay_sch_success boolean;
1532: lv_account_name jai_rgm_regns.attribute_code%type;
1533: ln_tax_variance_inv_cur number;
1534: ln_user_id fnd_user.user_id%type := fnd_global.user_id;

Line 2080: ln_precision fnd_currencies.precision%type;

2076: v_tax_installment number;
2077: v_payment_num ap_payment_schedules_all.payment_num%type;
2078: v_total_payment_amt number;
2079: v_diff_tax_amount number;
2080: ln_precision fnd_currencies.precision%type;
2081:
2082:
2083: cursor c_total_payment_amt is
2084: select sum(gross_amount)