APPS.PQP_GB_SWF_ARCHIVE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 883: from hr_assignment_set_amendments hasa1

879: where has1.assignment_set_id = p_asg_set_id
880: and has1.business_group_id = asg.business_group_id
881: and nvl(has1.payroll_id,asg.payroll_id) = asg.payroll_id
882: and (not exists (select 1 -- chk no amendments
883: from hr_assignment_set_amendments hasa1
884: where hasa1.assignment_set_id = has1.assignment_set_id)
885: or exists (select 1 -- chk include amendments
886: from hr_assignment_set_amendments hasa2
887: where hasa2.assignment_set_id = has1.assignment_set_id

Line 886: from hr_assignment_set_amendments hasa2

882: and (not exists (select 1 -- chk no amendments
883: from hr_assignment_set_amendments hasa1
884: where hasa1.assignment_set_id = has1.assignment_set_id)
885: or exists (select 1 -- chk include amendments
886: from hr_assignment_set_amendments hasa2
887: where hasa2.assignment_set_id = has1.assignment_set_id
888: and hasa2.assignment_id = asg.assignment_id
889: and nvl(hasa2.include_or_exclude,'I') = 'I')
890: or (not exists (select 1 --chk no exlude amendments

Line 891: from hr_assignment_set_amendments hasa3

887: where hasa2.assignment_set_id = has1.assignment_set_id
888: and hasa2.assignment_id = asg.assignment_id
889: and nvl(hasa2.include_or_exclude,'I') = 'I')
890: or (not exists (select 1 --chk no exlude amendments
891: from hr_assignment_set_amendments hasa3
892: where hasa3.assignment_set_id = has1.assignment_set_id
893: and hasa3.assignment_id = asg.assignment_id
894: and nvl(hasa3.include_or_exclude,'I') = 'E')
895: and not exists (select 1 --and chk no Inc amendments

Line 896: from hr_assignment_set_amendments hasa4

892: where hasa3.assignment_set_id = has1.assignment_set_id
893: and hasa3.assignment_id = asg.assignment_id
894: and nvl(hasa3.include_or_exclude,'I') = 'E')
895: and not exists (select 1 --and chk no Inc amendments
896: from hr_assignment_set_amendments hasa4
897: where hasa4.assignment_set_id = has1.assignment_set_id
898: and nvl(hasa4.include_or_exclude,'I') = 'I')
899: ) -- end checking exclude amendments
900: ) -- done checking amendments

Line 978: from hr_assignment_set_amendments hasa1

974: where has1.assignment_set_id = p_asg_set_id
975: and has1.business_group_id = asg.business_group_id
976: and nvl(has1.payroll_id,asg.payroll_id) = asg.payroll_id
977: and (not exists (select 1 -- chk no amendments
978: from hr_assignment_set_amendments hasa1
979: where hasa1.assignment_set_id = has1.assignment_set_id)
980: or exists (select 1 -- chk include amendments
981: from hr_assignment_set_amendments hasa2
982: where hasa2.assignment_set_id = has1.assignment_set_id

Line 981: from hr_assignment_set_amendments hasa2

977: and (not exists (select 1 -- chk no amendments
978: from hr_assignment_set_amendments hasa1
979: where hasa1.assignment_set_id = has1.assignment_set_id)
980: or exists (select 1 -- chk include amendments
981: from hr_assignment_set_amendments hasa2
982: where hasa2.assignment_set_id = has1.assignment_set_id
983: and hasa2.assignment_id = asg.assignment_id
984: and nvl(hasa2.include_or_exclude,'I') = 'I')
985: or (not exists (select 1 --chk no exlude amendments

Line 986: from hr_assignment_set_amendments hasa3

982: where hasa2.assignment_set_id = has1.assignment_set_id
983: and hasa2.assignment_id = asg.assignment_id
984: and nvl(hasa2.include_or_exclude,'I') = 'I')
985: or (not exists (select 1 --chk no exlude amendments
986: from hr_assignment_set_amendments hasa3
987: where hasa3.assignment_set_id = has1.assignment_set_id
988: and hasa3.assignment_id = asg.assignment_id
989: and nvl(hasa3.include_or_exclude,'I') = 'E')
990: and not exists (select 1 --and chk no Inc amendments

Line 991: from hr_assignment_set_amendments hasa4

987: where hasa3.assignment_set_id = has1.assignment_set_id
988: and hasa3.assignment_id = asg.assignment_id
989: and nvl(hasa3.include_or_exclude,'I') = 'E')
990: and not exists (select 1 --and chk no Inc amendments
991: from hr_assignment_set_amendments hasa4
992: where hasa4.assignment_set_id = has1.assignment_set_id
993: and nvl(hasa4.include_or_exclude,'I') = 'I')
994: ) -- end checking exclude amendments
995: ) -- done checking amendments