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