APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_JOBS

Line 721: ,per_jobs job

717: IS
718: SELECT nvl(pos.name,job.name) name
719: FROM per_positions pos
720: ,per_assignments_f asg
721: ,per_jobs job
722: WHERE asg.position_id=pos.position_id(+)
723: AND asg.job_id=job.job_id(+)
724: AND asg.person_id = p_person_id
725: AND asg.primary_flag = 'Y'

Line 1004: ,per_jobs job

1000: IS
1001: SELECT nvl(pos.name,job.name) name
1002: FROM per_all_positions pos
1003: ,per_assignments_f asg
1004: ,per_jobs job
1005: WHERE asg.position_id=pos.position_id(+)
1006: AND asg.job_id=job.job_id(+)
1007: AND asg.assignment_id = p_assignment_id
1008: AND asg.business_group_id = g_bg_id

Line 2312: ,per_jobs job

2308: IS
2309: SELECT nvl(pos.name,job.name) name
2310: FROM per_all_positions pos
2311: ,per_assignments_f asg
2312: ,per_jobs job
2313: WHERE asg.position_id=pos.position_id(+)
2314: AND asg.job_id=job.job_id(+)
2315: AND asg.assignment_id = p_assignment_id
2316: AND asg.business_group_id = g_bg_id