DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on PER_JOBS

Line 72: , per_jobs pj

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

Line 226: , per_jobs pj

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