DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on FND_GLOBAL

Line 32: where ppl.person_id = fnd_global.employee_id

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(+)
36: and p_effective_date

Line 189: where ppl.person_id = fnd_global.employee_id

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(+)
193: and p_effective_date