APPS.AHL_PRD_WORKORDER_PUB dependencies on FND_LOOKUP_VALUES_VL

Line 1342: FROM FND_LOOKUP_VALUES_VL

1338:
1339: CURSOR get_operation_status(c_operation_status VARCHAR2)
1340: IS
1341: SELECT lookup_code
1342: FROM FND_LOOKUP_VALUES_VL
1343: WHERE lookup_type='AHL_OPERATION_STATUS'
1344: AND UPPER(meaning)=UPPER(c_operation_status)
1345: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE))
1346: AND TRUNC(NVL(end_date_active,SYSDATE+1));