select package_id from application_groups where group_id = :group_id select substr(instance_name, 1, 90) from apm_packages where package_id = :package_id delete from acs_permissions where grantee_id = :group_id or grantee_id in (select segment_id from rel_segments where group_id = :group_id) or grantee_id in (select rel_id from acs_rels where object_id_one = :group_id or object_id_two = :group_id)