DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on JL_ZZ_AR_TX_FSC_CLS

Line 196: JL_ZZ_AR_TX_FSC_CLS FSC

192: SELECT 1
193: FROM
194: zx_evnt_cls_mappings evntmap,
195: FND_LOOKUPS LK,
196: JL_ZZ_AR_TX_FSC_CLS FSC
197: where
198: lines_gt.application_id = evntmap.application_id
199: and lines_gt.entity_code = evntmap.entity_code
200: and lines_gt.event_class_code = evntmap.event_class_code

Line 529: FROM JL_ZZ_AR_TX_FSC_CLS

525: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
526: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
527: AND EXISTS
528: (SELECT 1
529: FROM JL_ZZ_AR_TX_FSC_CLS
530: WHERE fiscal_classification_code = fc.classification_code
531: AND enabled_flag = 'Y')
532: ) Temp
533: ON ( Lines.trx_id = Temp.trx_id)

Line 801: FROM JL_ZZ_AR_TX_FSC_CLS

797: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
798: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
799: AND EXISTS
800: (SELECT 1
801: FROM JL_ZZ_AR_TX_FSC_CLS
802: WHERE fiscal_classification_code = fc.classification_code
803: AND enabled_flag = 'Y')
804: AND rownum = 1; -- Bug 5701599
805: