APPS.AHL_VWP_TIMES_PVT dependencies on AHL_OPERATIONS_B_KFV

Line 1468: FROM ahl_operations_b_kfv

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)
1468: FROM ahl_operations_b_kfv
1469: WHERE concatenated_segments = O.concatenated_segments
1470: AND trunc(sysdate) between trunc(start_date_active) and
1471: trunc(NVL(end_date_active,SYSDATE+1))
1472: );