APPS.PAY_US_MMREF_REPORTING1 dependencies on HR_ORGANIZATION_INFORMATION

Line 216: FROM hr_organization_information hoi,

212: RETURN BOOLEAN IS
213: -- Cursor to get all the GREs belonging to the given business group
214: CURSOR c_get_gre IS
215: SELECT hou.organization_id gre
216: FROM hr_organization_information hoi,
217: hr_all_organization_units hou
218: WHERE hou.business_group_id = p_business_group_id AND
219: hoi.organization_id = hou.organization_id AND
220: hoi.org_information_context = 'CLASS' AND

Line 224: FROM hr_organization_information

220: hoi.org_information_context = 'CLASS' AND
221: hoi.org_information1 = 'HR_LEGAL' AND
222: NOT EXISTS (
223: SELECT 'Y'
224: FROM hr_organization_information
225: WHERE organization_id = hou.organization_id
226: AND org_information_context = '1099R Magnetic Report Rules');
227:
228: -- Check if the GRE needs to be archived.

Line 840: FROM hr_organization_information hoi

836: AND paf.effective_end_date >= ppa.start_date
837: AND paf.assignment_type = ''E''
838: AND not exists (
839: SELECT ''x''
840: FROM hr_organization_information hoi
841: WHERE hoi.organization_id = paa.tax_unit_id
842: and hoi.org_information_context =
843: ''1099R Magnetic Report Rules'')
844: ORDER BY paf.person_id

Line 889: FROM hr_organization_information hoi

885: and pustif.effective_end_date
886: and pustif.sit_exists = ''Y'')
887: AND not exists (
888: SELECT ''x''
889: FROM hr_organization_information hoi
890: WHERE hoi.organization_id = paa.tax_unit_id
891: and hoi.org_information_context =
892: ''1099R Magnetic Report Rules''
893: )

Line 977: from hr_organization_information hou

973: and pustif.effective_end_date
974: and pustif.sit_exists = 'Y'
975: )
976: and exists (select 'x'
977: from hr_organization_information hou
978: where hou.organization_id = paa.tax_unit_id
979: and hou.org_information16 = 'P'
980: and hou.org_information_context = 'W2 Reporting Rules')
981: and not exists

Line 984: from hr_organization_information hoi

980: and hou.org_information_context = 'W2 Reporting Rules')
981: and not exists
982: (
983: select 'x'
984: from hr_organization_information hoi
985: where hoi.organization_id = paa.tax_unit_id
986: and hoi.org_information_context ='1099R Magnetic Report Rules'
987: )
988: ORDER BY 1, 3, 4 DESC, 2

Line 1043: from hr_organization_information hoi

1039: )
1040: and not exists
1041: (
1042: select 'x'
1043: from hr_organization_information hoi
1044: WHERE hoi.organization_id = paa.tax_unit_id
1045: and hoi.org_information_context ='1099R Magnetic Report Rules'
1046: )
1047: ORDER BY 1, 3, 4 DESC, 2

Line 1074: FROM hr_organization_information hoi

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

Line 1536: SELECT org_information17 from hr_organization_information

1532: and hou.organization_id = paa.tax_unit_id;
1533:
1534: CURSOR c_get_pr_control_num ( cp_tax_unit_id number)
1535: IS
1536: SELECT org_information17 from hr_organization_information
1537: WHERE org_information_context = 'W2 Reporting Rules'
1538: AND organization_id = cp_tax_unit_id;
1539:
1540: CURSOR c_sit_check (cp_payroll_action_id number,