APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on AR_VAT_TAX_ALL_B

Line 346: FROM ar_vat_tax_all_b vat --Bugfix 2367111

342: l_tax_calculation_plsql_block,
343: l_tax_type,
344: l_vat_tax_id,
345: l_tax_category_id
346: FROM ar_vat_tax_all_b vat --Bugfix 2367111
347: WHERE vat.set_of_books_id = l_set_of_books_id
348: AND vat.tax_code = p_tax_code
349: AND p_tax_date BETWEEN vat.start_date
350: AND NVL(vat.end_date, TO_DATE( '31122199', 'DDMMYYYY'))

Line 897: FROM ar_vat_tax_all_b vat --Bugfix 2367111

893: vat.tax_regime_code,
894: vat.tax,
895: vat.tax_status_code,
896: vat.tax_code
897: FROM ar_vat_tax_all_b vat --Bugfix 2367111
898: WHERE vat.set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
899: AND vat.tax_code = l_tax_code
900: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date BETWEEN vat.start_date AND
901: NVL(vat.end_date, TO_DATE('31122199', 'DDMMYYYY'))