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.JAI_AP_TDS_POP_RPST_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 199: FROM jai_cmn_tax_ctg_lines jctcl

195: ,p_section_type varchar2
196: ) IS
197: SELECT jcta.tax_rate
198: ,jcta.tax_id
199: FROM jai_cmn_tax_ctg_lines jctcl
200: ,jai_cmn_taxes_all jcta
201: WHERE jctcl.tax_id = jcta.tax_id
202: AND jctcl.tax_category_id = p_tax_category_id
203: AND jcta.section_type = p_section_type

Line 602: From jai_cmn_tax_ctg_lines jctcl

598: And NVL(jatr.source_invoice_deleted, G_N) = G_N
599: And jatr.tax_category_id is not null
600: And not exists ( --make sure under surcharge slab
601: Select 1
602: From jai_cmn_tax_ctg_lines jctcl
603: ,jai_cmn_taxes_all jcta
604: ,jai_ap_tds_repo_lines jatrl
605: Where jctcl.tax_id = jcta.tax_id
606: And jctcl.tax_category_id = jatr.tax_category_id

Line 779: From jai_cmn_tax_ctg_lines jctcl

775:
776:
777: cursor c_get_tax_from_category(p_tax_category_id in NUMBER) is
778: Select jctcl.tax_id
779: From jai_cmn_tax_ctg_lines jctcl
780: ,Jai_cmn_taxes_all jcta
781: Where jcta.tax_id = jctcl.tax_id
782: AND jctcl.tax_category_id = p_tax_category_id
783: AND jcta.tax_type in (G_TDS, G_TDS_EDUCATION_CESS, G_TDS_SH_EDU_CESS, G_TDS_SURCHARGE ); --exclude WCT/ESSI

Line 2046: ,JAI_CMN_TAX_CTG_LINES jctcl

2042: ,jcta.tax_name
2043: ,jcta.tax_rate
2044: ,jcta.tax_type
2045: FROM JAI_CMN_TAXES_ALL jcta
2046: ,JAI_CMN_TAX_CTG_LINES jctcl
2047: WHERE jctcl.tax_category_id = ln_tax_category_id
2048: AND jcta.tax_id = jctcl.tax_id
2049: AND jcta.tax_type IN (G_TDS, G_TDS_EDUCATION_CESS, G_TDS_EDUCATION_CESS, G_TDS_SURCHARGE)
2050: )