96: ,per_all_assignments_f asg
97: ,per_all_people_f p2
98: ,per_all_assignments_f asg2
99: -- ,per_addresses ad
100: ,hr_locations loc
101: ,hr_all_organization_units org
102: WHERE pp.person_id = p_person_id
103: AND trunc(sysdate) BETWEEN pp.effective_start_date AND pp.effective_end_date
104: and asg.person_id = pp.person_id