eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PRV_BUS dependencies on PER_ALL_PEOPLE

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';

Line 904: , per_all_people per

900: cursor csr_leg_code is
901: select pbg.legislation_code
902: from per_business_groups pbg
903: , per_performance_reviews prv
904: , per_all_people per
905: where prv.performance_review_id = p_performance_review_id
906: and per.person_id = prv.person_id
907: and per.business_group_id = pbg.business_group_id;
908: --