3153: CURSOR c_rep_pos(p_person_id NUMBER
3154: ,p_effective_date DATE)
3155: IS
3156: SELECT nvl(pos.name,job.name) name
3157: FROM per_positions pos
3158: ,per_assignments_f asg
3159: ,per_jobs job
3160: WHERE asg.position_id=pos.position_id(+)
3161: AND asg.job_id=job.job_id(+)
3821: CURSOR c_rep_pos(p_person_id NUMBER
3822: ,p_effective_date DATE)
3823: IS
3824: SELECT nvl(pos.name,job.name) name
3825: FROM per_positions pos
3826: ,per_assignments_f asg
3827: ,per_jobs job
3828: WHERE asg.position_id=pos.position_id(+)
3829: AND asg.job_id=job.job_id(+)