751: IS
752: SELECT nvl(pos.name,job.name) name
753: FROM per_all_positions pos
754: ,per_assignments_f asg 755: ,per_jobs job 756: WHERE asg.position_id=pos.position_id(+)
757: AND asg.job_id=job.job_id(+)
758: AND asg.person_id = p_person_id
759: AND asg.primary_flag = 'Y'