select t.package_name, lower(t.id_column) as id_column from acs_object_types t where t.object_type = :group_type select group_id from groups where group_name = :group_name SELECT g.group_id FROM acs_rels rels INNER JOIN composition_rels comp ON rels.rel_id = comp.rel_id INNER JOIN groups g ON rels.object_id_two = g.group_id WHERE rels.object_id_one = :application_group_id AND g.group_name = :group_name select distinct member_id from group_member_map where group_id = :group_id select distinct m.member_id from group_member_map m, acs_objects o where m.group_id = :group_id and m.member_id = o.object_id and o.object_type = :type select join_policy from groups where group_id = :group_id select segment_id from rel_segments where group_id = :group_id and rel_type = :type