Line 3671: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,
3667: ,p_effective_date IN DATE
3668: )
3669: IS
3670: select user_id 3671: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf, 3672: per_all_people_f linkppf
3673: where p_effective_date between paf.effective_start_date and
3674: paf.effective_end_date
3675: and p_effective_date between usr.start_date and