DBA Data[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PER_ALL_PEOPLE_F

Line 2783: FROM per_all_people_f ppf,

2779: hr_utility.set_location('pay_us_geo_upd_pkg.check_time',9);
2780:
2781: SELECT ppf.person_id
2782: INTO l_person_id
2783: FROM per_all_people_f ppf,
2784: per_all_assignments_f paf
2785: WHERE ppf.person_id = paf.person_id
2786: AND paf.assignment_id = p_assign_id
2787: AND ppf.effective_start_date = (SELECT max(ppf2.effective_start_date)

Line 2788: FROM per_all_people_f ppf2

2784: per_all_assignments_f paf
2785: WHERE ppf.person_id = paf.person_id
2786: AND paf.assignment_id = p_assign_id
2787: AND ppf.effective_start_date = (SELECT max(ppf2.effective_start_date)
2788: FROM per_all_people_f ppf2
2789: WHERE ppf2.person_id = ppf.person_id);
2790:
2791:
2792: write_message(