APPS.AHL_RM_ASSO_DOCASO_PVT dependencies on AHL_ROUTES_B

Line 350: UPDATE ahl_routes_b

346: OPEN get_route_status (p_x_association_tbl(1).OBJECT_ID);
347: FETCH get_route_status INTO l_obj_status;
348: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
349: THEN
350: UPDATE ahl_routes_b
351: SET revision_status_code = 'DRAFT'
352: WHERE route_id = p_x_association_tbl(1).OBJECT_ID;
353: END IF;
354: CLOSE get_route_status;