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 JL_ZZ_AR_TX_CATEG

Line 666: JL_ZZ_AR_TX_CATEG TXC

662: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,--CTA.TAX_ATTRIBUTE_VALUE ATTRIBUTE8,
663: TGR.CALCULATE_IN_OE,
664: TXC.TAX_CATEGORY
665: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111
666: JL_ZZ_AR_TX_CATEG TXC
667: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
668: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
669: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >= NVL(TGR.START_DATE_ACTIVE,
670: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE)

Line 716: JL_ZZ_AR_TX_CATEG TXC

712: TGR.ESTABLISHMENT_TYPE ATTRIBUTE5 ,
713: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,
714: TGR.CALCULATE_IN_OE
715: FROM JL_ZZ_AR_TX_GROUPS TGR ,
716: JL_ZZ_AR_TX_CATEG TXC
717: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
718: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
719: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >=
720: NVL(TGR.START_DATE_ACTIVE,

Line 775: JL_ZZ_AR_TX_CATEG TXC

771: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,--CTA.TAX_ATTRIBUTE_VALUE ATTRIBUTE8,
772: TGR.CALCULATE_IN_OE,
773: TXC.TAX_CATEGORY
774: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111
775: JL_ZZ_AR_TX_CATEG TXC
776: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
777: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
778: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >= NVL(TGR.START_DATE_ACTIVE,
779: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE)

Line 826: JL_ZZ_AR_TX_CATEG TXC

822: TGR.ESTABLISHMENT_TYPE ATTRIBUTE5 ,
823: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,
824: TGR.CALCULATE_IN_OE
825: FROM JL_ZZ_AR_TX_GROUPS TGR ,
826: JL_ZZ_AR_TX_CATEG TXC
827: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
828: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
829: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >=
830: NVL(TGR.START_DATE_ACTIVE,

Line 1423: JL_ZZ_AR_TX_CATEG TXC

1419: TGR.ESTABLISHMENT_TYPE,
1420: TGR.CONTRIBUTOR_TYPE,
1421: TXC.TAX_CATEGORY
1422: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111
1423: JL_ZZ_AR_TX_CATEG TXC
1424: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
1425: AND TGR.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
1426: AND NVL(TXC.START_DATE_ACTIVE, ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE) <=
1427: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE