DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on PER_JOBS

Line 31: , per_jobs pj

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'
35: and pasg.job_id = pj.job_id(+)

Line 188: , per_jobs pj

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'
192: and pasg.job_id = pj.job_id(+)