[Home] [Help]
256: RETURN BOOLEAN IS
257: -- Cursor to get all the GREs belonging to the given business group
258: CURSOR c_get_gre IS
259: SELECT hou.organization_id gre
260: FROM hr_organization_information hoi,
261: hr_all_organization_units hou
262: WHERE hou.business_group_id = p_business_group_id AND
263: hoi.organization_id = hou.organization_id AND
264: hoi.org_information_context = 'CLASS' AND
264: hoi.org_information_context = 'CLASS' AND
265: hoi.org_information1 = 'HR_LEGAL' AND
266: NOT EXISTS (
267: SELECT 'Y'
268: FROM hr_organization_information
269: WHERE organization_id = hou.organization_id
270: AND org_information_context = '1099R Magnetic Report Rules');
271:
272: -- Check if the GRE needs to be archived.
884: AND paf.effective_end_date >= ppa.start_date
885: AND paf.assignment_type = ''E''
886: AND not exists (
887: SELECT ''x''
888: FROM hr_organization_information hoi
889: WHERE hoi.organization_id = paa.tax_unit_id
890: and hoi.org_information_context =
891: ''1099R Magnetic Report Rules'')
892: ORDER BY paf.person_id
937: and pustif.effective_end_date
938: and pustif.sit_exists = ''Y'')
939: AND not exists (
940: SELECT ''x''
941: FROM hr_organization_information hoi
942: WHERE hoi.organization_id = paa.tax_unit_id
943: and hoi.org_information_context =
944: ''1099R Magnetic Report Rules''
945: )
1033: and paf.person_id between p_stperson AND p_endperson
1034: and not exists
1035: (
1036: select 'x'
1037: from hr_organization_information hoi
1038: WHERE hoi.organization_id = paa.tax_unit_id
1039: and hoi.org_information_context ='1099R Magnetic Report Rules'
1040: )
1041: and rtrim(ltrim(fai1.value)) <> '0'
1067: AND paf.effective_start_date <= ppa.effective_date
1068: AND paf.effective_end_date >= ppa.start_date
1069: AND not exists (
1070: SELECT 'x'
1071: FROM hr_organization_information hoi
1072: WHERE hoi.organization_id = paa.tax_unit_id
1073: and hoi.org_information_context = '1099R Magnetic Report Rules')
1074: ORDER BY 1, 3, 4 DESC, 2
1075: FOR UPDATE OF paf.assignment_id;