APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on ZX_RATES_B

Line 201: lv_tax_rate_code zx_rates_b.tax_rate_code%type;

197: ln_allocated_cnt NUMBER;
198: ln_del_errored_cnt NUMBER;
199: ln_upd_errored_cnt NUMBER;
200: ln_ins_errored_cnt NUMBER;
201: lv_tax_rate_code zx_rates_b.tax_rate_code%type;
202: lv_vat_trans_type zx_rates_b.vat_transaction_type_code%type;
203: lv_alloc_flag VARCHAR2(1);
204:
205: CURSOR c_get_alloc_flags IS

Line 202: lv_vat_trans_type zx_rates_b.vat_transaction_type_code%type;

198: ln_del_errored_cnt NUMBER;
199: ln_upd_errored_cnt NUMBER;
200: ln_ins_errored_cnt NUMBER;
201: lv_tax_rate_code zx_rates_b.tax_rate_code%type;
202: lv_vat_trans_type zx_rates_b.vat_transaction_type_code%type;
203: lv_alloc_flag VARCHAR2(1);
204:
205: CURSOR c_get_alloc_flags IS
206: SELECT nvl(map_jzvre.enable_allocations_flag, g_no) enable_allocations,

Line 701: from zx_rates_b

697: lv_vat_trans_type := NULL;
698:
699: select tax_rate_code, vat_transaction_type_code
700: into lv_tax_rate_code, lv_vat_trans_type
701: from zx_rates_b
702: where tax_rate_id = l_trx_rec.tax_rate_id;
703:
704: if l_trx_rec.tax_rate_code = lv_tax_rate_code then
705: if (l_trx_rec.vat_trans_type is null AND lv_vat_trans_type is null)