APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on ZX_RATES_B

Line 200: lv_tax_rate_code zx_rates_b.tax_rate_code%type;

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

Line 201: lv_vat_trans_type zx_rates_b.vat_transaction_type_code%type;

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

Line 669: from zx_rates_b

665: lv_vat_trans_type := NULL;
666:
667: select tax_rate_code, vat_transaction_type_code
668: into lv_tax_rate_code, lv_vat_trans_type
669: from zx_rates_b
670: where tax_rate_id = l_trx_rec.tax_rate_id;
671:
672: if l_trx_rec.tax_rate_code = lv_tax_rate_code then
673: if (l_trx_rec.vat_trans_type is null AND lv_vat_trans_type is null)