DBA Data[Home] [Help]

APPS.PER_NEW_HIRE_PKG dependencies on PER_ALL_PEOPLE_F

Line 2504: per_all_people_f ppf, --table

2500: job.name,
2501: ppf.work_telephone
2502: From
2503: --per_people_f ppf, --view bug 4912696
2504: per_all_people_f ppf, --table
2505: --per_assignments_f paf, --view bug 4912696
2506: per_all_assignments_f paf, --table
2507: per_jobs job
2508: Where

Line 2521: from per_all_people_f ppf1 --table bug 4912696

2517: and paf.effective_end_date
2518: -- BUG2919553
2519: And ppf.effective_start_date =
2520: (select max(ppf1.effective_start_date)
2521: from per_all_people_f ppf1 --table bug 4912696
2522: where ppf1.person_id = ppf.person_id
2523: and ppf1.effective_start_date <= p_report_date
2524: )
2525: -- End of BUG2919553