DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on JL_ZZ_AR_TX_GROUPS_ALL

Line 677: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111

673: TGR.TAX_CATEGORY_ID NUMERIC_ATTRIBUTE1,
674: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,--CTA.TAX_ATTRIBUTE_VALUE ATTRIBUTE8,
675: TGR.CALCULATE_IN_OE,
676: TXC.TAX_CATEGORY
677: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111
678: JL_ZZ_AR_TX_CATEG TXC
679: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
680: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
681: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >= NVL(TGR.START_DATE_ACTIVE,

Line 786: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111

782: TGR.TAX_CATEGORY_ID NUMERIC_ATTRIBUTE1,
783: TGR.CONTRIBUTOR_TYPE ATTRIBUTE8,--CTA.TAX_ATTRIBUTE_VALUE ATTRIBUTE8,
784: TGR.CALCULATE_IN_OE,
785: TXC.TAX_CATEGORY
786: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111
787: JL_ZZ_AR_TX_CATEG TXC
788: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
789: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE <= TGR.END_DATE_ACTIVE
790: AND ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE >= NVL(TGR.START_DATE_ACTIVE,

Line 1465: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111

1461: TGR.TRANSACTION_NATURE,
1462: TGR.ESTABLISHMENT_TYPE,
1463: TGR.CONTRIBUTOR_TYPE,
1464: TXC.TAX_CATEGORY
1465: FROM JL_ZZ_AR_TX_GROUPS_ALL TGR , --Bugfix 2367111
1466: JL_ZZ_AR_TX_CATEG TXC
1467: WHERE TGR.GROUP_TAX_ID = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2
1468: AND TGR.TAX_CATEGORY_ID = TXC.TAX_CATEGORY_ID
1469: AND NVL(TXC.START_DATE_ACTIVE, ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.TRX_DATE) <=