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 642: FROM AHL_ROUTE_OPERATIONS_V

638:
639: CURSOR get_dup_rec ( c_route_id NUMBER )
640: IS
641: SELECT step, concatenated_segments
642: FROM AHL_ROUTE_OPERATIONS_V
643: WHERE route_id = c_route_id
644: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE
645: ORDER BY step, concatenated_segments;
646:

Line 649: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;

645: ORDER BY step, concatenated_segments;
646:
647: l_step NUMBER;
648: l_prev_step NUMBER;
649: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
650: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
651:
652: BEGIN
653:

Line 650: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;

646:
647: l_step NUMBER;
648: l_prev_step NUMBER;
649: l_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
650: l_prev_operation AHL_ROUTE_OPERATIONS_V.concatenated_segments%TYPE;
651:
652: BEGIN
653:
654: -- Check whether any duplicate route_operation records (based on step) for the given route_id