DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PER_JOBS

Line 3371: ,per_jobs job

3367: IS
3368: SELECT nvl(pos.name,job.name) name
3369: FROM per_positions pos
3370: ,per_assignments_f asg
3371: ,per_jobs job
3372: WHERE asg.position_id=pos.position_id(+)
3373: AND asg.job_id=job.job_id(+)
3374: AND asg.person_id = p_person_id
3375: AND asg.primary_flag = 'Y'

Line 4047: ,per_jobs job

4043: IS
4044: SELECT nvl(pos.name,job.name) name
4045: FROM per_positions pos
4046: ,per_assignments_f asg
4047: ,per_jobs job
4048: WHERE asg.position_id=pos.position_id(+)
4049: AND asg.job_id=job.job_id(+)
4050: AND asg.person_id = p_person_id
4051: AND asg.primary_flag = 'Y'