select icr.manifest_id from imsld_cp_resources icr, cr_items cri where icr.resource_id = cri.live_revision and cri.item_id = :resource_id