DBA Data[Home] [Help]

APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT dependencies on FND_LOOKUP_VALUES

Line 484: FROM FND_LOOKUP_VALUES

480: FROM ahl_mr_headers_b MR,
481: ahl_mr_headers_tl MR_TL,
482: (SELECT LOOKUP_CODE,
483: MEANING
484: FROM FND_LOOKUP_VALUES
485: WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'
486: AND LANGUAGE = USERENV('LANG')
487: ) STATUS
488: WHERE MR.mr_header_id = p_mr_header_id

Line 748: FROM FND_LOOKUP_VALUES

744: FROM ahl_mr_headers_b MR,
745: ahl_mr_headers_tl MR_TL,
746: (SELECT LOOKUP_CODE,
747: MEANING
748: FROM FND_LOOKUP_VALUES
749: WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'
750: AND LANGUAGE = USERENV('LANG')
751: ) STATUS,
752: AHL_MR_LOOP_CHAIN_RELNS rel

Line 919: FROM FND_LOOKUP_VALUES

915: eff.accomplish_trigger_type relationship
916: FROM ahl_unit_effectivities_b eff,
917: (SELECT LOOKUP_CODE,
918: MEANING
919: FROM FND_LOOKUP_VALUES
920: WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'
921: AND LANGUAGE = USERENV('LANG')
922: ) STATUS,
923: ahl_mr_headers_b MR,