DBA Data[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PER_ALL_PEOPLE_F

Line 2490: FROM per_all_people_f ppf,

2486: hr_utility.set_location('pay_us_geo_upd_pkg.check_time',9);
2487:
2488: SELECT ppf.person_id
2489: INTO l_person_id
2490: FROM per_all_people_f ppf,
2491: per_all_assignments_f paf
2492: WHERE ppf.person_id = paf.person_id
2493: AND paf.assignment_id = p_assign_id
2494: AND ppf.effective_start_date = (SELECT max(ppf2.effective_start_date)

Line 2495: FROM per_all_people_f ppf2

2491: per_all_assignments_f paf
2492: WHERE ppf.person_id = paf.person_id
2493: AND paf.assignment_id = p_assign_id
2494: AND ppf.effective_start_date = (SELECT max(ppf2.effective_start_date)
2495: FROM per_all_people_f ppf2
2496: WHERE ppf2.person_id = ppf.person_id);
2497:
2498:
2499: write_message(