APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 1843: FROM hr_assignment_set_amendments hasa1

1839: WHERE has1.assignment_set_id = p_asg_set_id
1840: AND has1.business_group_id = asg.business_group_id
1841: AND nvl(has1.payroll_id, asg.payroll_id) = asg.payroll_id
1842: AND (NOT EXISTS (SELECT 1 -- chk no amendmts
1843: FROM hr_assignment_set_amendments hasa1
1844: WHERE hasa1.assignment_set_id =
1845: has1.assignment_set_id)
1846: OR EXISTS (SELECT 1 -- chk include amendmts
1847: FROM hr_assignment_set_amendments hasa2

Line 1847: FROM hr_assignment_set_amendments hasa2

1843: FROM hr_assignment_set_amendments hasa1
1844: WHERE hasa1.assignment_set_id =
1845: has1.assignment_set_id)
1846: OR EXISTS (SELECT 1 -- chk include amendmts
1847: FROM hr_assignment_set_amendments hasa2
1848: WHERE hasa2.assignment_set_id =
1849: has1.assignment_set_id
1850: AND hasa2.assignment_id = asg.assignment_id
1851: AND nvl(hasa2.include_or_exclude,'I') = 'I')

Line 1853: FROM hr_assignment_set_amendments hasa3

1849: has1.assignment_set_id
1850: AND hasa2.assignment_id = asg.assignment_id
1851: AND nvl(hasa2.include_or_exclude,'I') = 'I')
1852: OR (NOT EXISTS (SELECT 1 --chk no exlude amendmts
1853: FROM hr_assignment_set_amendments hasa3
1854: WHERE hasa3.assignment_set_id =
1855: has1.assignment_set_id
1856: AND hasa3.assignment_id = asg.assignment_id
1857: AND nvl(hasa3.include_or_exclude,'I') = 'E')

Line 1859: FROM hr_assignment_set_amendments hasa4

1855: has1.assignment_set_id
1856: AND hasa3.assignment_id = asg.assignment_id
1857: AND nvl(hasa3.include_or_exclude,'I') = 'E')
1858: AND NOT EXISTS (SELECT 1 --and chk no Inc amendmts
1859: FROM hr_assignment_set_amendments hasa4
1860: WHERE hasa4.assignment_set_id =
1861: has1.assignment_set_id
1862: AND nvl(hasa4.include_or_exclude,'I') = 'I') ) -- end checking exclude amendmts
1863: ) -- done checking amendments

Line 1927: FROM hr_assignment_set_amendments hasa1

1923: WHERE has1.assignment_set_id = p_asg_set_id
1924: AND has1.business_group_id = pass.business_group_id
1925: AND nvl(has1.payroll_id, pass.payroll_id) = pass.payroll_id
1926: AND (NOT EXISTS (SELECT 1 -- chk no amendmts
1927: FROM hr_assignment_set_amendments hasa1
1928: WHERE hasa1.assignment_set_id =
1929: has1.assignment_set_id)
1930: OR EXISTS (SELECT 1 -- chk include amendmts
1931: FROM hr_assignment_set_amendments hasa2

Line 1931: FROM hr_assignment_set_amendments hasa2

1927: FROM hr_assignment_set_amendments hasa1
1928: WHERE hasa1.assignment_set_id =
1929: has1.assignment_set_id)
1930: OR EXISTS (SELECT 1 -- chk include amendmts
1931: FROM hr_assignment_set_amendments hasa2
1932: WHERE hasa2.assignment_set_id =
1933: has1.assignment_set_id
1934: AND hasa2.assignment_id = pass.assignment_id
1935: AND nvl(hasa2.include_or_exclude,'I') = 'I')

Line 1937: FROM hr_assignment_set_amendments hasa3

1933: has1.assignment_set_id
1934: AND hasa2.assignment_id = pass.assignment_id
1935: AND nvl(hasa2.include_or_exclude,'I') = 'I')
1936: OR (NOT EXISTS (SELECT 1 --chk no exlude amendmts
1937: FROM hr_assignment_set_amendments hasa3
1938: WHERE hasa3.assignment_set_id =
1939: has1.assignment_set_id
1940: AND hasa3.assignment_id = pass.assignment_id
1941: AND nvl(hasa3.include_or_exclude,'I') = 'E')

Line 1943: FROM hr_assignment_set_amendments hasa4

1939: has1.assignment_set_id
1940: AND hasa3.assignment_id = pass.assignment_id
1941: AND nvl(hasa3.include_or_exclude,'I') = 'E')
1942: AND NOT EXISTS (SELECT 1 --and chk no Inc amendmts
1943: FROM hr_assignment_set_amendments hasa4
1944: WHERE hasa4.assignment_set_id =
1945: has1.assignment_set_id
1946: AND nvl(hasa4.include_or_exclude,'I') = 'I')
1947: ) -- end checking exclude amendmts