2770: WHERE OP.operation_id=RO.operation_id
2771: AND ro.ROUTE_ID = p_route_id
2772: AND OP.revision_number IN
2773: ( SELECT MAX(OP1.revision_number)
2774: FROM AHL_OPERATIONS_B_KFV OP1
2775: WHERE OP1.concatenated_segments=OP.concatenated_segments
2776: AND OP1.revision_status_code='COMPLETE'
2777: AND TRUNC(SYSDATE) BETWEEN TRUNC(OP1.start_date_active) AND
2778: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))
2790: WHERE OP.operation_id=RO.operation_id
2791: AND ro.ROUTE_ID = p_route_id
2792: AND OP.revision_number IN
2793: ( SELECT MAX(OP1.revision_number)
2794: FROM AHL_OPERATIONS_B_KFV OP1
2795: WHERE OP1.concatenated_segments=OP.concatenated_segments
2796: AND OP1.revision_status_code='COMPLETE'
2797: AND TRUNC(SYSDATE) BETWEEN TRUNC(OP1.start_date_active) AND
2798: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))