APPS.PAY_US_MAGW2_REPORTING dependencies on HR_ORGANIZATION_INFORMATION

Line 195: FROM hr_organization_information hoi,

191: RETURN BOOLEAN IS
192: -- Cursor to get all the GREs belonging to the given business group
193: CURSOR c_get_gre IS
194: SELECT hou.organization_id gre
195: FROM hr_organization_information hoi,
196: hr_organization_units hou
197: WHERE hou.business_group_id+0 = p_business_group_id AND
198: hoi.organization_id = hou.organization_id AND
199: hoi.org_information_context = 'CLASS' AND

Line 203: FROM hr_organization_information

199: hoi.org_information_context = 'CLASS' AND
200: hoi.org_information1 = 'HR_LEGAL' AND
201: NOT EXISTS (
202: SELECT 'Y'
203: FROM hr_organization_information
204: WHERE organization_id = hou.organization_id
205: AND org_information_context = '1099R Magnetic Report Rules');
206: -- Check if the GRE needs to be archived.
207: -- Cursor to fetch people in a given GRE with earnings in the given state to

Line 823: FROM hr_organization_information hoi

819: AND paf.effective_end_date >= ppa.start_date
820: AND paf.assignment_type = ''E''
821: AND not exists (
822: SELECT ''x''
823: FROM hr_organization_information hoi
824: WHERE hoi.organization_id = paa.tax_unit_id
825: and hoi.org_information_context =
826: ''1099R Magnetic Report Rules'')
827: ORDER BY paf.person_id

Line 872: FROM hr_organization_information hoi

868: and pustif.effective_end_date
869: and pustif.sit_exists = ''Y'')
870: AND not exists (
871: SELECT ''x''
872: FROM hr_organization_information hoi
873: WHERE hoi.organization_id = paa.tax_unit_id
874: and hoi.org_information_context =
875: ''1099R Magnetic Report Rules''
876: )

Line 961: from hr_organization_information hoi

957: )
958: and not exists
959: (
960: select 'x'
961: from hr_organization_information hoi
962: WHERE hoi.organization_id = paa.tax_unit_id
963: and hoi.org_information_context ='1099R Magnetic Report Rules'
964: )
965: ORDER BY 1, 3, 4 DESC, 2

Line 996: FROM hr_organization_information hoi

992: --AND hsck.segment1 = paa.tax_unit_id
993: --AND hsck.segment1 NOT IN (
994: AND not exists (
995: SELECT 'x'
996: FROM hr_organization_information hoi
997: WHERE hoi.organization_id = paa.tax_unit_id
998: and hoi.org_information_context = '1099R Magnetic Report Rules')
999: ORDER BY 1, 3, 4 DESC, 2
1000: FOR UPDATE OF paf.assignment_id;