select t.package_name, lower(t.id_column) as id_column from acs_object_types t where t.object_type = :party_type select name from organizations where organization_id = :party_id select group_name from groups where group_id = :party_id select party_name from party_names where party_id = :party_id select 1 from parties where party_id = :object_id