DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_POSITIONS

Line 692: FROM per_positions pos

688:
689: CURSOR c_pos(p_person_id NUMBER)
690: IS
691: SELECT nvl(pos.name,job.name) name
692: FROM per_positions pos
693: ,per_assignments_f asg
694: ,per_jobs job
695: WHERE asg.position_id=pos.position_id(+)
696: AND asg.job_id=job.job_id(+)