DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on FND_LOOKUPS

Line 308: FND_LOOKUPS LK,

304: SELECT 1
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

Line 363: FND_LOOKUPS LK,

359: SELECT 1
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

Line 1629: (SELECT 1 FROM FND_LOOKUPS lkp

1625:
1626: -- Check for Validity of Transaction line class
1627: nvl2(lines_gt.line_class,
1628: CASE WHEN (NOT EXISTS
1629: (SELECT 1 FROM FND_LOOKUPS lkp
1630: WHERE lines_gt.line_class = lkp.lookup_code
1631: AND lkp.lookup_type = 'ZX_LINE_CLASS'))
1632: THEN 'Y'
1633: ELSE NULL