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 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