select upper(id_column) from acs_object_types where object_type='group' select t.table_name as references_table, t.id_column as references_column from acs_object_types t where t.object_type = :supertype insert into group_types (group_type) values (:group_type)