oracle8.1.6
select ci.item_id as assessment_id, cr.title
from cr_folders cf, cr_items ci, cr_revisions cr, as_assessments a
where cr.revision_id = ci.latest_revision
and a.assessment_id = cr.revision_id
and ci.parent_id = cf.folder_id and cf.package_id = :old_package_id
order by cr.title