DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 71: , per_all_assignments_f pasg

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
75: and pasg.primary_flag = 'Y'

Line 225: , per_all_assignments_f pasg

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
229: and pasg.primary_flag = 'Y'