APPS.AHL_VWP_TIMES_PVT dependencies on AHL_OPERATIONS_B_KFV

Line 1378: FROM ahl_operations_b_kfv

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)
1378: FROM ahl_operations_b_kfv
1379: WHERE concatenated_segments = O.concatenated_segments
1380: AND trunc(sysdate) between trunc(start_date_active) and
1381: trunc(NVL(end_date_active,SYSDATE+1))
1382: );