DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on FND_GLOBAL

Line 73: where ppl.person_id = fnd_global.employee_id

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

Line 227: where ppl.person_id = fnd_global.employee_id

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