APPS.AHL_RM_ASSO_DOCASO_PVT dependencies on AHL_ROUTES_B

Line 320: UPDATE ahl_routes_b

316: OPEN get_route_status (p_x_association_tbl(1).OBJECT_ID);
317: FETCH get_route_status INTO l_obj_status;
318: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
319: THEN
320: UPDATE ahl_routes_b
321: SET revision_status_code = 'DRAFT'
322: WHERE route_id = p_x_association_tbl(1).OBJECT_ID;
323: END IF;
324: CLOSE get_route_status;