DBA Data[Home] [Help]

APPS.PAY_IN_PF_ARCHIVE dependencies on PER_JOBS

Line 759: ,per_jobs job

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