APPS.AHL_RM_OP_ROUTE_AS_PVT dependencies on AHL_ROUTE_OPERATIONS_V

Line 311: FROM AHL_ROUTE_OPERATIONS_V

307: attribute12,
308: attribute13,
309: attribute14,
310: attribute15
311: FROM AHL_ROUTE_OPERATIONS_V
312: WHERE route_operation_id = c_route_operation_id;
313:
314: BEGIN
315:

Line 647: FROM AHL_ROUTE_OPERATIONS_V

643:
644: CURSOR get_dup_rec ( c_route_id NUMBER )
645: IS
646: SELECT step, concatenated_segments
647: FROM AHL_ROUTE_OPERATIONS_V
648: WHERE route_id = c_route_id
649: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE
650: ORDER BY step, concatenated_segments;
651:

Line 654: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;

650: ORDER BY step, concatenated_segments;
651:
652: l_step NUMBER;
653: l_prev_step NUMBER;
654: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
655: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
656:
657: BEGIN
658:

Line 655: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;

651:
652: l_step NUMBER;
653: l_prev_step NUMBER;
654: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
655: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
656:
657: BEGIN
658:
659: -- Check whether any duplicate route_operation records (based on step) for the given route_id

Line 729: FROM ahl_route_operations_v

725: -- Pekambar Added for USAF - VEE
726: CURSOR duplicate_step(c_concatenated_segments AHL_OPERATIONS_B_KFV.CONCATENATED_SEGMENTS%TYPE, c_step NUMBER,c_route_id NUMBER)
727: IS
728: SELECT 'X'
729: FROM ahl_route_operations_v
730: WHERE concatenated_segments <> c_concatenated_segments
731: AND step = c_step
732: AND route_id = c_route_id
733: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;