APPS.PAY_US_MMREF_REPORTING dependencies on HR_ORGANIZATION_INFORMATION

Line 318: FROM hr_organization_information hoi,

314: RETURN BOOLEAN IS
315: -- Cursor to get all the GREs belonging to the given business group
316: CURSOR c_get_gre IS
317: SELECT hou.organization_id gre
318: FROM hr_organization_information hoi,
319: hr_all_organization_units hou
320: WHERE hou.business_group_id = p_business_group_id AND
321: hoi.organization_id = hou.organization_id AND
322: hoi.org_information_context = 'CLASS' AND

Line 326: FROM hr_organization_information

322: hoi.org_information_context = 'CLASS' AND
323: hoi.org_information1 = 'HR_LEGAL' AND
324: NOT EXISTS (
325: SELECT 'Y'
326: FROM hr_organization_information
327: WHERE organization_id = hou.organization_id
328: AND org_information_context = '1099R Magnetic Report Rules');
329:
330: -- Check if the GRE needs to be archived.

Line 941: FROM hr_organization_information hoi

937: AND paf.effective_end_date >= ppa.start_date
938: AND paf.assignment_type = ''E''
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: ORDER BY paf.person_id

Line 1009: 'FROM hr_organization_information hoi '||

1005: 'and pustif.sit_exists = ''Y'') '||
1006:
1007: 'AND not exists ( '||
1008: 'SELECT ''x'' '||
1009: 'FROM hr_organization_information hoi '||
1010: 'WHERE hoi.organization_id = paa.tax_unit_id '||
1011: 'and hoi.org_information_context = '||
1012: '''1099R Magnetic Report Rules'' '||
1013: ') '||

Line 1077: 'FROM hr_organization_information hoi '||

1073: 'and pustif.sit_exists = ''Y'') '||
1074:
1075: 'AND not exists ( '||
1076: 'SELECT ''x'' '||
1077: 'FROM hr_organization_information hoi '||
1078: 'WHERE hoi.organization_id = paa.tax_unit_id '||
1079: 'and hoi.org_information_context = '||
1080: '''1099R Magnetic Report Rules'' '||
1081: ') '||

Line 1127: FROM hr_organization_information hoi

1123: and pustif.effective_end_date
1124: and pustif.sit_exists = ''Y'')
1125: AND not exists (
1126: SELECT ''x''
1127: FROM hr_organization_information hoi
1128: WHERE hoi.organization_id = paa.tax_unit_id
1129: and hoi.org_information_context =
1130: ''1099R Magnetic Report Rules''
1131: )

Line 1223: from hr_organization_information hou

1219: and pustif.effective_end_date
1220: and pustif.sit_exists = 'Y'
1221: )
1222: and exists (select 'x'
1223: from hr_organization_information hou
1224: where hou.organization_id = paa.tax_unit_id
1225: and hou.org_information16 = 'P'
1226: and hou.org_information_context = 'W2 Reporting Rules')
1227: and not exists

Line 1230: from hr_organization_information hoi

1226: and hou.org_information_context = 'W2 Reporting Rules')
1227: and not exists
1228: (
1229: select 'x'
1230: from hr_organization_information hoi
1231: where hoi.organization_id = paa.tax_unit_id
1232: and hoi.org_information_context ='1099R Magnetic Report Rules'
1233: )
1234: ORDER BY 1, 3, 4 DESC, 2

Line 1296: from hr_organization_information hoi

1292: */
1293: and not exists
1294: (
1295: select 'x'
1296: from hr_organization_information hoi
1297: WHERE hoi.organization_id = paa.tax_unit_id
1298: and hoi.org_information_context ='1099R Magnetic Report Rules'
1299: )
1300: ORDER BY 1, 3, 4 DESC, 2 ;

Line 1378: from hr_organization_information hoi

1374: )
1375: and not exists
1376: (
1377: select 'x'
1378: from hr_organization_information hoi
1379: WHERE hoi.organization_id = paa.tax_unit_id
1380: and hoi.org_information_context ='1099R Magnetic Report Rules'
1381: )
1382: ORDER BY 1, 3, 4 DESC, 2 ;

Line 1455: from hr_organization_information hoi

1451: )
1452: and not exists
1453: (
1454: select 'x'
1455: from hr_organization_information hoi
1456: WHERE hoi.organization_id = paa.tax_unit_id
1457: and hoi.org_information_context ='1099R Magnetic Report Rules'
1458: )
1459: ORDER BY 1, 3, 4 DESC, 2 ;

Line 1488: FROM hr_organization_information hoi

1484: AND paf.effective_start_date <= ppa.effective_date
1485: AND paf.effective_end_date >= ppa.start_date
1486: AND not exists (
1487: SELECT 'x'
1488: FROM hr_organization_information hoi
1489: WHERE hoi.organization_id = paa.tax_unit_id
1490: and hoi.org_information_context = '1099R Magnetic Report Rules')
1491: ORDER BY 1, 3, 4 DESC, 2
1492: FOR UPDATE OF paf.assignment_id;

Line 2024: SELECT org_information17 from hr_organization_information

2020: and hou.organization_id = paa.tax_unit_id;
2021:
2022: CURSOR c_get_pr_control_num ( cp_tax_unit_id number)
2023: IS
2024: SELECT org_information17 from hr_organization_information
2025: WHERE org_information_context = 'W2 Reporting Rules'
2026: AND organization_id = cp_tax_unit_id;
2027:
2028: CURSOR c_sit_check (cp_payroll_action_id number,