DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on AR_VAT_TAX_ALL_B

Line 338: FROM ar_vat_tax_all_b vat --Bugfix 2367111

334: l_tax_calculation_plsql_block,
335: l_tax_type,
336: l_vat_tax_id,
337: l_tax_category_id
338: FROM ar_vat_tax_all_b vat --Bugfix 2367111
339: WHERE vat.set_of_books_id = l_set_of_books_id
340: AND vat.tax_code = p_tax_code
341: AND p_tax_date BETWEEN vat.start_date
342: AND NVL(vat.end_date, TO_DATE( '31122199', 'DDMMYYYY'))

Line 885: FROM ar_vat_tax_all_b vat --Bugfix 2367111

881: vat.tax_regime_code,
882: vat.tax,
883: vat.tax_status_code,
884: vat.tax_code
885: FROM ar_vat_tax_all_b vat --Bugfix 2367111
886: WHERE vat.set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
887: AND vat.tax_code = l_tax_code
888: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date BETWEEN vat.start_date AND
889: NVL(vat.end_date, TO_DATE('31122199', 'DDMMYYYY'))