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