select t.package_name, lower(t.id_column) as id_column
from acs_object_types t
where t.object_type = :group_type
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 member_id
from group_member_map
where group_id = :group_id
select m.member_id
from group_member_map m, persons p
where m.group_id = :group_id
and m.member_id = p.person_id
select m.member_id
from group_member_map m, users u
where m.group_id = :group_id
and m.member_id = u.user_id
select join_policy from groups where group_id = :group_id
select group_id
from groups
where group_name = :group_name
select segment_id
from rel_segments
where group_id = :group_id
and rel_type = :type