eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on AR_VAT_TAX_ALL

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'))

Line 1668: AR_VAT_TAX_ALL V

1664: BEGIN
1665: SELECT V.vat_tax_id
1666: INTO l_group_tax_id
1667: FROM RA_CUSTOMER_TRX_LINES_ALL TL,
1668: AR_VAT_TAX_ALL V
1669: WHERE TL.customer_trx_line_id =
1670: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.previous_customer_trx_line_id
1671: AND TL.TAX_CLASSIFICATION_CODE = V.tax_code --TL.vat_tax_id = V.vat_tax_id
1672: AND TL.org_id = V.org_id