APPS.AHL_RM_OP_ROUTE_AS_PVT dependencies on AHL_ROUTES_B

Line 922: UPDATE ahl_routes_b

918: OPEN get_route_status (p_route_id);
919: FETCH get_route_status INTO l_route_status;
920: IF (get_route_status%FOUND AND l_route_status = 'APPROVAL_REJECTED')
921: THEN
922: UPDATE ahl_routes_b
923: SET revision_status_code = 'DRAFT'
924: WHERE route_id = p_route_id;
925: END IF;
926: CLOSE get_route_status;