APPS.AHL_RM_OP_ROUTE_AS_PVT dependencies on AHL_ROUTES_B

Line 722: FROM ahl_routes_b

718:
719: CURSOR get_route_source(p_route_id IN NUMBER)
720: IS
721: SELECT enigma_source_code,route_no
722: FROM ahl_routes_b
723: WHERE route_id = p_route_id;
724:
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)

Line 966: UPDATE ahl_routes_b

962: OPEN get_route_status (p_route_id);
963: FETCH get_route_status INTO l_route_status;
964: IF (get_route_status%FOUND AND l_route_status = 'APPROVAL_REJECTED')
965: THEN
966: UPDATE ahl_routes_b
967: SET revision_status_code = 'DRAFT'
968: WHERE route_id = p_route_id;
969: END IF;
970: CLOSE get_route_status;