Line 661: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,
657: ,p_effective_date IN DATE
658: )
659: IS
660: select user_id 661: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf, 662: per_all_people_f linkppf
663: where p_effective_date between paf.effective_start_date and
664: paf.effective_end_date
665: and p_effective_date between usr.start_date and