APPS.AHL_VWP_TIMES_PVT dependencies on AHL_OPERATIONS_VL

Line 1463: FROM ahl_operations_vl O, ahl_route_operations RO

1459: get_op_level_res_reqs_rec c_get_op_level_res_reqs%ROWTYPE;
1460:
1461: CURSOR c_get_oprns (c_route_id IN NUMBER) IS
1462: SELECT RO.operation_id
1463: FROM ahl_operations_vl O, ahl_route_operations RO
1464: WHERE O.operation_id = RO.operation_id
1465: AND RO.route_id = c_route_id
1466: AND O.revision_status_code = 'COMPLETE'
1467: AND O.revision_number IN (SELECT max(revision_number)