478: ppt.system_person_type
479: FROM
480: per_all_people_f papf,
481: per_person_type_usages_f ptu, 482: per_person_types ppt 483: where papf.person_id=p_successor_id
484: and papf.person_id=ptu.person_id
485: and ptu.person_type_id=ppt.person_type_id
486: and trunc(sysdate) between ptu.effective_start_date and ptu.effective_end_date