DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on JL_ZZ_AR_TX_FSC_CLS

Line 309: JL_ZZ_AR_TX_FSC_CLS FSC

305: FROM
306: zx_trx_headers_gt header,
307: zx_evnt_cls_mappings evntmap,
308: FND_LOOKUPS LK,
309: JL_ZZ_AR_TX_FSC_CLS FSC
310: where
311: lines_gt.application_id = header.application_id
312: and lines_gt.entity_code = header.entity_code
313: and lines_gt.event_class_code = header.event_class_code

Line 364: JL_ZZ_AR_TX_FSC_CLS FSC

360: FROM
361: zx_trx_headers_gt header,
362: zx_evnt_cls_mappings evntmap,
363: FND_LOOKUPS LK,
364: JL_ZZ_AR_TX_FSC_CLS FSC
365: where
366: lines_gt.application_id = header.application_id
367: and lines_gt.entity_code = header.entity_code
368: and lines_gt.event_class_code = header.event_class_code

Line 730: FROM JL_ZZ_AR_TX_FSC_CLS

726: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
727: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
728: AND EXISTS
729: (SELECT 1
730: FROM JL_ZZ_AR_TX_FSC_CLS
731: WHERE fiscal_classification_code = fc.classification_code
732: AND enabled_flag = 'Y')
733: ) Temp
734: ON ( Lines.trx_id = Temp.trx_id AND

Line 997: FROM JL_ZZ_AR_TX_FSC_CLS

993: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
994: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
995: AND EXISTS
996: (SELECT 1
997: FROM JL_ZZ_AR_TX_FSC_CLS
998: WHERE fiscal_classification_code = fc.classification_code
999: AND enabled_flag = 'Y')
1000: AND rownum = 1; -- Bug 5701599
1001: