SELECT
a.project_id,
r.one_line as role_name,
p.first_names || ' ' || p.last_name as user_name,
a.party_id,
r.is_lead_p
FROM
pm_project_assignment a,
pm_roles r,
persons p
WHERE
a.role_id = r.role_id and
a.party_id = p.person_id and
project_id = :project_item_id
and exists (select 1 from acs_object_party_privilege_map ppm
where ppm.object_id = :project_item_id
and ppm.privilege = 'read'
and ppm.party_id = :user_id)
ORDER BY
r.role_id, p.first_names, p.last_name
SELECT
a.project_id,
r.one_line as role_name,
a.party_id,
r.is_lead_p
FROM
pm_project_assignment a,
pm_roles r
WHERE
a.role_id = r.role_id and
project_id = :project_item_id
and exists (select 1 from acs_object_party_privilege_map ppm
where ppm.object_id = :project_item_id
and ppm.privilege = 'read'
and ppm.party_id = :user_id)
ORDER BY
r.role_id
select
group_name
from
groups
where
group_id = :party_id
select
p.first_names || ' ' || p.last_name as name
from
persons p
where
person_id = :party_id