postgresql7.1
select acs_object__name(:party_id)
from dual
select cal_item__name(:cal_item_id)
from dual
select acs_object__name(party_id)
as pretty_name,
party_id
from parties
select distinct(grantee_id) as party_id,
acs_object__name(grantee_id) as name
from acs_permissions
where object_id = :cal_item_id