DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 30: , per_all_assignments_f pasg

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

Line 187: , per_all_assignments_f pasg

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