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(+)
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(+)