select distinct papf1.full_name emp_name
               ,papf1.person_id
               ,papf2.full_name super_name
               ,paaf.supervisor_id
from   per_all_people_f papf1, per_all_people_f papf2, per_all_assignments_f paaf
where  papf1.person_id = paaf.person_id
and    papf2.person_id = paaf.supervisor_id;