APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 1891: FROM hr_assignment_set_amendments hasa1

1887: WHERE has1.assignment_set_id = p_asg_set_id
1888: AND has1.business_group_id = asg.business_group_id
1889: AND nvl(has1.payroll_id, asg.payroll_id) = asg.payroll_id
1890: AND (NOT EXISTS (SELECT 1 -- chk no amendmts
1891: FROM hr_assignment_set_amendments hasa1
1892: WHERE hasa1.assignment_set_id =
1893: has1.assignment_set_id)
1894: OR EXISTS (SELECT 1 -- chk include amendmts
1895: FROM hr_assignment_set_amendments hasa2

Line 1895: FROM hr_assignment_set_amendments hasa2

1891: FROM hr_assignment_set_amendments hasa1
1892: WHERE hasa1.assignment_set_id =
1893: has1.assignment_set_id)
1894: OR EXISTS (SELECT 1 -- chk include amendmts
1895: FROM hr_assignment_set_amendments hasa2
1896: WHERE hasa2.assignment_set_id =
1897: has1.assignment_set_id
1898: AND hasa2.assignment_id = asg.assignment_id
1899: AND nvl(hasa2.include_or_exclude,'I') = 'I')

Line 1901: FROM hr_assignment_set_amendments hasa3

1897: has1.assignment_set_id
1898: AND hasa2.assignment_id = asg.assignment_id
1899: AND nvl(hasa2.include_or_exclude,'I') = 'I')
1900: OR (NOT EXISTS (SELECT 1 --chk no exlude amendmts
1901: FROM hr_assignment_set_amendments hasa3
1902: WHERE hasa3.assignment_set_id =
1903: has1.assignment_set_id
1904: AND hasa3.assignment_id = asg.assignment_id
1905: AND nvl(hasa3.include_or_exclude,'I') = 'E')

Line 1907: FROM hr_assignment_set_amendments hasa4

1903: has1.assignment_set_id
1904: AND hasa3.assignment_id = asg.assignment_id
1905: AND nvl(hasa3.include_or_exclude,'I') = 'E')
1906: AND NOT EXISTS (SELECT 1 --and chk no Inc amendmts
1907: FROM hr_assignment_set_amendments hasa4
1908: WHERE hasa4.assignment_set_id =
1909: has1.assignment_set_id
1910: AND nvl(hasa4.include_or_exclude,'I') = 'I') ) -- end checking exclude amendmts
1911: ) -- done checking amendments

Line 1976: FROM hr_assignment_set_amendments hasa1

1972: WHERE has1.assignment_set_id = p_asg_set_id
1973: AND has1.business_group_id = pass.business_group_id
1974: AND nvl(has1.payroll_id, pass.payroll_id) = pass.payroll_id
1975: AND (NOT EXISTS (SELECT 1 -- chk no amendmts
1976: FROM hr_assignment_set_amendments hasa1
1977: WHERE hasa1.assignment_set_id =
1978: has1.assignment_set_id)
1979: OR EXISTS (SELECT 1 -- chk include amendmts
1980: FROM hr_assignment_set_amendments hasa2

Line 1980: FROM hr_assignment_set_amendments hasa2

1976: FROM hr_assignment_set_amendments hasa1
1977: WHERE hasa1.assignment_set_id =
1978: has1.assignment_set_id)
1979: OR EXISTS (SELECT 1 -- chk include amendmts
1980: FROM hr_assignment_set_amendments hasa2
1981: WHERE hasa2.assignment_set_id =
1982: has1.assignment_set_id
1983: AND hasa2.assignment_id = pass.assignment_id
1984: AND nvl(hasa2.include_or_exclude,'I') = 'I')

Line 1986: FROM hr_assignment_set_amendments hasa3

1982: has1.assignment_set_id
1983: AND hasa2.assignment_id = pass.assignment_id
1984: AND nvl(hasa2.include_or_exclude,'I') = 'I')
1985: OR (NOT EXISTS (SELECT 1 --chk no exlude amendmts
1986: FROM hr_assignment_set_amendments hasa3
1987: WHERE hasa3.assignment_set_id =
1988: has1.assignment_set_id
1989: AND hasa3.assignment_id = pass.assignment_id
1990: AND nvl(hasa3.include_or_exclude,'I') = 'E')

Line 1992: FROM hr_assignment_set_amendments hasa4

1988: has1.assignment_set_id
1989: AND hasa3.assignment_id = pass.assignment_id
1990: AND nvl(hasa3.include_or_exclude,'I') = 'E')
1991: AND NOT EXISTS (SELECT 1 --and chk no Inc amendmts
1992: FROM hr_assignment_set_amendments hasa4
1993: WHERE hasa4.assignment_set_id =
1994: has1.assignment_set_id
1995: AND nvl(hasa4.include_or_exclude,'I') = 'I')
1996: ) -- end checking exclude amendmts