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 64: from per_all_people_f

60: -- Declare cursors and local variables
61: --
62: cursor c_potential_applicant_details is
63: select first_name
64: from per_all_people_f
65: where person_id = p_person_id;
66: --
67: cursor c_recruiter_details is
68: select ppl.full_name

Line 70: from per_all_people_f ppl

66: --
67: cursor c_recruiter_details is
68: select ppl.full_name
69: , pj.name job_name
70: from per_all_people_f ppl
71: , per_all_assignments_f pasg
72: , per_jobs pj
73: where ppl.person_id = fnd_global.employee_id
74: and ppl.person_id = pasg.person_id

Line 218: from per_all_people_f

214: -- Declare cursors and local variables
215: --
216: cursor c_potential_applicant_details is
217: select first_name
218: from per_all_people_f
219: where person_id = p_person_id;
220: --
221: cursor c_recruiter_details is
222: select ppl.full_name

Line 224: from per_all_people_f ppl

220: --
221: cursor c_recruiter_details is
222: select ppl.full_name
223: , pj.name job_name
224: from per_all_people_f ppl
225: , per_all_assignments_f pasg
226: , per_jobs pj
227: where ppl.person_id = fnd_global.employee_id
228: and ppl.person_id = pasg.person_id