DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_JOBS

Line 694: ,per_jobs job

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(+)
697: AND asg.person_id = p_person_id
698: AND asg.primary_flag = 'Y'

Line 923: ,per_jobs job

919: IS
920: SELECT nvl(pos.name,job.name) name
921: FROM per_all_positions pos
922: ,per_assignments_f asg
923: ,per_jobs job
924: WHERE asg.position_id=pos.position_id(+)
925: AND asg.job_id=job.job_id(+)
926: AND asg.assignment_id = p_assignment_id
927: AND asg.business_group_id = g_bg_id

Line 2206: ,per_jobs job

2202: IS
2203: SELECT nvl(pos.name,job.name) name
2204: FROM per_all_positions pos
2205: ,per_assignments_f asg
2206: ,per_jobs job
2207: WHERE asg.position_id=pos.position_id(+)
2208: AND asg.job_id=job.job_id(+)
2209: AND asg.assignment_id = p_assignment_id
2210: AND asg.business_group_id = g_bg_id