292: per_addresses per_addr,
293: fnd_territories per_ft,
294: per_periods_of_service serv,
295: per_all_assignments_f asg,
296: per_collective_agreements col_agr
297: where per.person_id = p_emp_id
298: and asg.person_id = per.person_id
299: and per.effective_end_date = (select max(effective_end_date)
300: from per_all_people_f