APPS.AHL_VWP_TIMES_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 1373: FROM ahl_operations_vl O, ahl_route_operations RO

1369: get_op_level_res_reqs_rec c_get_op_level_res_reqs%ROWTYPE;
1370:
1371: CURSOR c_get_oprns (c_route_id IN NUMBER) IS
1372: SELECT RO.operation_id
1373: FROM ahl_operations_vl O, ahl_route_operations RO
1374: WHERE O.operation_id = RO.operation_id
1375: AND RO.route_id = c_route_id
1376: AND O.revision_status_code = 'COMPLETE'
1377: AND O.revision_number IN (SELECT max(revision_number)