DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PER_JOBS

Line 3159: ,per_jobs job

3155: IS
3156: SELECT nvl(pos.name,job.name) name
3157: FROM per_positions pos
3158: ,per_assignments_f asg
3159: ,per_jobs job
3160: WHERE asg.position_id=pos.position_id(+)
3161: AND asg.job_id=job.job_id(+)
3162: AND asg.person_id = p_person_id
3163: AND asg.primary_flag = 'Y'

Line 3827: ,per_jobs job

3823: IS
3824: SELECT nvl(pos.name,job.name) name
3825: FROM per_positions pos
3826: ,per_assignments_f asg
3827: ,per_jobs job
3828: WHERE asg.position_id=pos.position_id(+)
3829: AND asg.job_id=job.job_id(+)
3830: AND asg.person_id = p_person_id
3831: AND asg.primary_flag = 'Y'