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.IRC_VACANCY_CONSIDERATIONS_API dependencies on PER_ALL_PEOPLE_F

Line 23: from per_all_people_f

19: -- Declare cursors and local variables
20: --
21: cursor c_potential_applicant_details is
22: select first_name
23: from per_all_people_f
24: where person_id = p_person_id;
25: --
26: cursor c_recruiter_details is
27: select ppl.full_name

Line 29: from per_all_people_f ppl

25: --
26: cursor c_recruiter_details is
27: select ppl.full_name
28: , pj.name job_name
29: from per_all_people_f ppl
30: , per_all_assignments_f pasg
31: , per_jobs pj
32: where ppl.person_id = fnd_global.employee_id
33: and ppl.person_id = pasg.person_id

Line 180: from per_all_people_f

176: -- Declare cursors and local variables
177: --
178: cursor c_potential_applicant_details is
179: select first_name
180: from per_all_people_f
181: where person_id = p_person_id;
182: --
183: cursor c_recruiter_details is
184: select ppl.full_name

Line 186: from per_all_people_f ppl

182: --
183: cursor c_recruiter_details is
184: select ppl.full_name
185: , pj.name job_name
186: from per_all_people_f ppl
187: , per_all_assignments_f pasg
188: , per_jobs pj
189: where ppl.person_id = fnd_global.employee_id
190: and ppl.person_id = pasg.person_id