DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_JOBS

Line 596: ,per_jobs job

592: IS
593: SELECT nvl(pos.name,job.name) name
594: FROM per_all_positions pos
595: ,per_assignments_f asg
596: ,per_jobs job
597: WHERE asg.position_id=pos.position_id(+)
598: AND asg.job_id=job.job_id(+)
599: AND asg.assignment_id = p_assignment_id
600: AND asg.business_group_id = g_bg_id

Line 2413: ,per_jobs job

2409: IS
2410: SELECT nvl(pos.name,job.name) name
2411: FROM per_all_positions pos
2412: ,per_assignments_f asg
2413: ,per_jobs job
2414: WHERE asg.position_id=pos.position_id(+)
2415: AND asg.job_id=job.job_id(+)
2416: AND asg.person_id = p_person_id
2417: AND asg.primary_flag = 'Y'