APPS.AHL_PRD_OPERATIONS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 763: FROM FND_LOOKUP_VALUES_VL

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

Line 998: FND_LOOKUP_VALUES_VL FNDL

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