APPS.PAY_GB_RTI_P60 dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 3302: FROM hr_assignment_set_amendments hasa1

3298: WHERE has1.assignment_set_id = c_asg_set_id
3299: -- AND has1.business_group_id = asg.business_group_id
3300: AND nvl(has1.payroll_id, paaf.payroll_id ) = paaf.payroll_id
3301: AND (NOT EXISTS (SELECT 1 -- chk no amendmts
3302: FROM hr_assignment_set_amendments hasa1
3303: WHERE hasa1.assignment_set_id =
3304: has1.assignment_set_id)
3305: OR EXISTS (SELECT 1 -- chk include amendmts
3306: FROM hr_assignment_set_amendments hasa2

Line 3306: FROM hr_assignment_set_amendments hasa2

3302: FROM hr_assignment_set_amendments hasa1
3303: WHERE hasa1.assignment_set_id =
3304: has1.assignment_set_id)
3305: OR EXISTS (SELECT 1 -- chk include amendmts
3306: FROM hr_assignment_set_amendments hasa2
3307: WHERE hasa2.assignment_set_id =
3308: has1.assignment_set_id
3309: AND hasa2.assignment_id = paaf.assignment_id
3310: AND nvl(hasa2.include_or_exclude,'I') = 'I')

Line 3312: FROM hr_assignment_set_amendments hasa3

3308: has1.assignment_set_id
3309: AND hasa2.assignment_id = paaf.assignment_id
3310: AND nvl(hasa2.include_or_exclude,'I') = 'I')
3311: OR (NOT EXISTS (SELECT 1 --chk no exlude amendmts
3312: FROM hr_assignment_set_amendments hasa3
3313: WHERE hasa3.assignment_set_id =
3314: has1.assignment_set_id
3315: AND hasa3.assignment_id = paaf.assignment_id
3316: AND nvl(hasa3.include_or_exclude,'I') = 'E')

Line 3318: FROM hr_assignment_set_amendments hasa4

3314: has1.assignment_set_id
3315: AND hasa3.assignment_id = paaf.assignment_id
3316: AND nvl(hasa3.include_or_exclude,'I') = 'E')
3317: AND NOT EXISTS (SELECT 1 --and chk no Inc amendmts
3318: FROM hr_assignment_set_amendments hasa4
3319: WHERE hasa4.assignment_set_id =
3320: has1.assignment_set_id
3321: AND nvl(hasa4.include_or_exclude,'I') = 'I') ) -- end checking exclude amendmts
3322: ) -- done checking amendments