select o.title,a.assessment_id
from as_assessments a, cr_items i, acs_objects o
where o.object_id=a.assessment_id
and i.latest_revision=a.assessment_id
and o.package_id=:assessment_package_id
select org_id
from ims_cp_organizations
where man_id=:man_id
select parent_id
from cr_items
where latest_revision=:org_id
select a.item_id as section_item_id,a.name,a.title
from cr_items ci, as_sectionsx a, as_assessment_section_map m
where m.assessment_id=:existing_object
and a.section_id=m.section_id
and ci.latest_revision=m.assessment_id
select res_id
from ims_cp_resources
where identifier=:section_item_id
and man_id=:man_id
select ims_item_id as item_id
from ims_cp_items
where org_id=:org_id
and identifier='as_sections_' || :section_item_id
select res_id
from ims_cp_resources
where identifier=:existing_object
and man_id=:man_id
select ims_item_id
from ims_cp_items
where org_id=:org_id
and identifier='::xowiki::Page_' || :existing_object