DBA Data[Home] [Help]

APPS.IRC_ASG_STATUS_API dependencies on FND_USER

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