select isshared from ims_cp_manifests where man_id = :man_id select man_id, lorsm_instance_id from ims_cp_manifest_class where man_id = :man_id and lorsm_instance_id = :package_id and community_id = :community_id