DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ARCHIVE dependencies on PER_JOBS

Line 2874: ,per_jobs job

2870: IS
2871: SELECT nvl(pos.name,job.name) name
2872: FROM per_positions pos
2873: ,per_assignments_f asg
2874: ,per_jobs job
2875: WHERE asg.position_id=pos.position_id(+)
2876: AND asg.job_id=job.job_id(+)
2877: AND asg.person_id = p_person_id
2878: AND asg.primary_flag = 'Y'