2748: IS
2749: SELECT nvl(pos.name,job.name) name
2750: FROM per_positions pos
2751: ,per_assignments_f asg 2752: ,per_jobs job 2753: WHERE asg.position_id=pos.position_id(+)
2754: AND asg.job_id=job.job_id(+)
2755: AND asg.person_id = p_person_id
2756: AND asg.primary_flag = 'Y'