select session_id
from as_sessions
where staff_id = :user_id
select session_id
from as_sessions
where subject_id = :user_id
select section_data_id
from as_section_data
where subject_id = :user_id
select section_data_id
from as_section_data
where staff_id = :user_id
select item_data_id
from as_item_data
where subject_id = :user_id
select item_data_id
from as_item_data
where staff_id = :user_id
update as_sessions
set staff_id = :to_user_id
where staff_id = :from_user_id
update as_sessions
set subject_id = :to_user_id
where subject_id = :from_user_id
update as_section_data
set subject_id = :to_user_id
where subject_id = :from_user_id
update as_section_data
set staff_id = :to_user_id
where staff_id = :from_user_id
update as_item_data
set subject_id = :to_user_id
where subject_id = :from_user_id
update as_item_data
set staff_id = :to_user_id
where staff_id = :from_user_id
update cr_items
set parent_id = (select folder_id
from cr_folders
where package_id=
(select package_id
from dotlrn_community_applets
where applet_id=
(select applet_id
from dotlrn_applets
where applet_key='dotlrn_assessment')
and community_id=:selected_community))
where item_id=(select context_id from acs_objects where object_id=:object_id);
update acs_objects
set context_id =(select folder_id
from cr_folders
where package_id=
(select package_id
from dotlrn_community_applets
where applet_id=
(select applet_id
from dotlrn_applets
where applet_key='dotlrn_assessment')
and community_id=:selected_community))
where object_id = (select context_id from acs_objects where object_id=:object_id)
update acs_objects
set package_id = (select package_id
from dotlrn_community_applets
where applet_id=
(select applet_id
from dotlrn_applets
where applet_key='dotlrn_assessment')
and community_id=:selected_community)
where object_id = (select context_id from acs_objects where object_id=:object_id)
update acs_objects
set package_id =(select package_id
from dotlrn_community_applets
where applet_id=
(select applet_id
from dotlrn_applets
where applet_key='dotlrn_assessment')
and community_id=:selected_community)
where object_id in (select object_id
from acs_objects
where context_id=
(select context_id
from acs_objects
where object_id=:object_id))