DBA Data[Home] [Help]

APPS.PER_PRV_BUS dependencies on PER_ALL_PEOPLE_F

Line 169: from per_all_people_f ppf

165: ,p_review_date in date) is
166:
167: cursor get_person is
168: select 1
169: from per_all_people_f ppf
170: where ppf.person_id=p_person_id
171: and p_review_date between ppf.effective_start_date
172: and ppf.effective_end_date
173: and ppf.current_employee_flag='Y';

Line 266: from per_all_people_f ppf

262: l_dummy number;
263: --
264: cursor get_person is
265: select 1
266: from per_all_people_f ppf
267: where ppf.person_id=p_person_id
268: and p_next_perf_review_date between ppf.effective_start_date
269: and ppf.effective_end_date
270: and ppf.current_employee_flag='Y';