select distinct p.first_names || ' ' || p.last_name as name, p.person_id as party_id FROM persons p, pm_project_assignment pa WHERE p.person_id = pa.party_id $users_clause