oracle8.1.6
select
cms_permission.permission_p (:module_id, :user_id, 'cm_admin')
from
dual
select
cms_permission.permission_p (:module_id, :user_id, 'cm_perm')
from
dual
select
g.group_id, g.group_name, p.email, p.url,
NVL((select 'f' from dual where exists (
select 1 from acs_rels
where object_id_one = :id
and rel_type in ('composition_rel', 'membership_rel'))),
't') as is_empty
from
groups g, parties p
where
g.group_id = :id
and
p.party_id = :id