APPS.AHL_PRD_OPERATIONS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 765: FROM FND_LOOKUP_VALUES_VL

761:
762: CURSOR get_operation_type(c_operation_type VARCHAR2)
763: IS
764: SELECT lookup_code
765: FROM FND_LOOKUP_VALUES_VL
766: WHERE lookup_type='AHL_OPERATION_TYPE'
767: AND UPPER(meaning)=UPPER(c_operation_type)
768: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE))
769: AND TRUNC(NVL(end_date_active,SYSDATE+1));

Line 1000: FND_LOOKUP_VALUES_VL FNDL

996: IS
997: SELECT AWOS.status_code,
998: FNDL.meaning
999: FROM AHL_WORKORDERS AWOS,
1000: FND_LOOKUP_VALUES_VL FNDL
1001: WHERE AWOS.workorder_id = c_wo_id
1002: AND FNDL.LOOKUP_CODE(+) = AWOS.STATUS_CODE
1003: AND FNDL.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS';
1004: -- Cursor added by Balaji for actual dates check issue with operation.