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 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 group_id
from groups
where group_name = :group_name
select segment_id
from rel_segments
where group_id = :group_id
and rel_type = :type
select 1 from group_approved_member_map where member_id = :party_id and group_id = :group_id