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 join_policy from groups where group_id = :group_id select group_id from groups where group_name = :group_name