APPS.PAY_US_MMREF_LOCAL dependencies on HR_ORGANIZATION_INFORMATION

Line 260: FROM hr_organization_information hoi,

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

Line 268: FROM hr_organization_information

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.

Line 888: FROM hr_organization_information hoi

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

Line 940: FROM hr_organization_information hoi

936: and pustif.effective_end_date
937: and pustif.sit_exists = ''Y'')
938: AND not exists (
939: SELECT ''x''
940: FROM hr_organization_information hoi
941: WHERE hoi.organization_id = paa.tax_unit_id
942: and hoi.org_information_context =
943: ''1099R Magnetic Report Rules''
944: )

Line 1036: from hr_organization_information hoi

1032: and paf.person_id between p_stperson AND p_endperson
1033: and not exists
1034: (
1035: select 'x'
1036: from hr_organization_information hoi
1037: WHERE hoi.organization_id = paa.tax_unit_id
1038: and hoi.org_information_context ='1099R Magnetic Report Rules'
1039: )
1040: and rtrim(ltrim(fai1.value)) <> '0'

Line 1070: FROM hr_organization_information hoi

1066: AND paf.effective_start_date <= ppa.effective_date
1067: AND paf.effective_end_date >= ppa.start_date
1068: AND not exists (
1069: SELECT 'x'
1070: FROM hr_organization_information hoi
1071: WHERE hoi.organization_id = paa.tax_unit_id
1072: and hoi.org_information_context = '1099R Magnetic Report Rules')
1073: ORDER BY 1, 3, 4 DESC, 2
1074: FOR UPDATE OF paf.assignment_id;