eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_MMREF_REPORTING dependencies on HR_ORGANIZATION_INFORMATION

Line 333: FROM hr_organization_information hoi,

329: RETURN BOOLEAN IS
330: -- Cursor to get all the GREs belonging to the given business group
331: CURSOR c_get_gre IS
332: SELECT hou.organization_id gre
333: FROM hr_organization_information hoi,
334: hr_all_organization_units hou
335: WHERE hou.business_group_id = p_business_group_id AND
336: hoi.organization_id = hou.organization_id AND
337: hoi.org_information_context = 'CLASS' AND

Line 341: FROM hr_organization_information

337: hoi.org_information_context = 'CLASS' AND
338: hoi.org_information1 = 'HR_LEGAL' AND
339: NOT EXISTS (
340: SELECT 'Y'
341: FROM hr_organization_information
342: WHERE organization_id = hou.organization_id
343: AND org_information_context = '1099R Magnetic Report Rules');
344:
345: -- Check if the GRE needs to be archived.

Line 966: FROM hr_organization_information hoi

962: AND paf.effective_end_date >= ppa.start_date
963: AND paf.assignment_type = ''E''
964: AND not exists (
965: SELECT ''x''
966: FROM hr_organization_information hoi
967: WHERE hoi.organization_id = paa.tax_unit_id
968: and hoi.org_information_context =
969: ''1099R Magnetic Report Rules'')
970: ORDER BY paf.person_id

Line 1034: 'FROM hr_organization_information hoi '||

1030: 'and pustif.sit_exists = ''Y'') '||
1031:
1032: 'AND not exists ( '||
1033: 'SELECT ''x'' '||
1034: 'FROM hr_organization_information hoi '||
1035: 'WHERE hoi.organization_id = paa.tax_unit_id '||
1036: 'and hoi.org_information_context = '||
1037: '''1099R Magnetic Report Rules'' '||
1038: ') '||

Line 1102: 'FROM hr_organization_information hoi '||

1098: 'and pustif.sit_exists = ''Y'') '||
1099:
1100: 'AND not exists ( '||
1101: 'SELECT ''x'' '||
1102: 'FROM hr_organization_information hoi '||
1103: 'WHERE hoi.organization_id = paa.tax_unit_id '||
1104: 'and hoi.org_information_context = '||
1105: '''1099R Magnetic Report Rules'' '||
1106: ') '||

Line 1152: FROM hr_organization_information hoi

1148: and pustif.effective_end_date
1149: and pustif.sit_exists = ''Y'')
1150: AND not exists (
1151: SELECT ''x''
1152: FROM hr_organization_information hoi
1153: WHERE hoi.organization_id = paa.tax_unit_id
1154: and hoi.org_information_context =
1155: ''1099R Magnetic Report Rules''
1156: )

Line 1248: from hr_organization_information hou

1244: and pustif.effective_end_date
1245: and pustif.sit_exists = 'Y'
1246: )
1247: and exists (select 'x'
1248: from hr_organization_information hou
1249: where hou.organization_id = paa.tax_unit_id
1250: and hou.org_information16 = 'P'
1251: and hou.org_information_context = 'W2 Reporting Rules')
1252: and not exists

Line 1255: from hr_organization_information hoi

1251: and hou.org_information_context = 'W2 Reporting Rules')
1252: and not exists
1253: (
1254: select 'x'
1255: from hr_organization_information hoi
1256: where hoi.organization_id = paa.tax_unit_id
1257: and hoi.org_information_context ='1099R Magnetic Report Rules'
1258: )
1259: ORDER BY 1, 3, 4 DESC, 2

Line 1322: from hr_organization_information hou

1318: and pustif.effective_end_date
1319: and pustif.sit_exists = 'Y'
1320: )
1321: and exists (select 'x'
1322: from hr_organization_information hou
1323: where hou.organization_id = paa.tax_unit_id
1324: and hou.org_information16 = 'P'
1325: and hou.org_information_context = 'W2 Reporting Rules')
1326: and not exists

Line 1329: from hr_organization_information hoi

1325: and hou.org_information_context = 'W2 Reporting Rules')
1326: and not exists
1327: (
1328: select 'x'
1329: from hr_organization_information hoi
1330: where hoi.organization_id = paa.tax_unit_id
1331: and hoi.org_information_context ='1099R Magnetic Report Rules'
1332: )
1333: ORDER BY 1, 3, 4 DESC, 2

Line 1396: from hr_organization_information hoi

1392: */
1393: and not exists
1394: (
1395: select 'x'
1396: from hr_organization_information hoi
1397: WHERE hoi.organization_id = paa.tax_unit_id
1398: and hoi.org_information_context ='1099R Magnetic Report Rules'
1399: )
1400: ORDER BY 1, 3, 4 DESC, 2 ;

Line 1464: from hr_organization_information hoi

1460: */
1461: and not exists
1462: (
1463: select 'x'
1464: from hr_organization_information hoi
1465: WHERE hoi.organization_id = paa.tax_unit_id
1466: and hoi.org_information_context ='1099R Magnetic Report Rules'
1467: )
1468: ORDER BY 1, 3, 4 DESC, 2 ;

Line 1545: from hr_organization_information hoi

1541: )
1542: and not exists
1543: (
1544: select 'x'
1545: from hr_organization_information hoi
1546: WHERE hoi.organization_id = paa.tax_unit_id
1547: and hoi.org_information_context ='1099R Magnetic Report Rules'
1548: )
1549: ORDER BY 1, 3, 4 DESC, 2 ;

Line 1623: from hr_organization_information hoi

1619: )
1620: and not exists
1621: (
1622: select 'x'
1623: from hr_organization_information hoi
1624: WHERE hoi.organization_id = paa.tax_unit_id
1625: and hoi.org_information_context ='1099R Magnetic Report Rules'
1626: )
1627: ORDER BY 1, 3, 4 DESC, 2 ;

Line 1700: from hr_organization_information hoi

1696: )
1697: and not exists
1698: (
1699: select 'x'
1700: from hr_organization_information hoi
1701: WHERE hoi.organization_id = paa.tax_unit_id
1702: and hoi.org_information_context ='1099R Magnetic Report Rules'
1703: )
1704: ORDER BY 1, 3, 4 DESC, 2 ;

Line 1777: from hr_organization_information hoi

1773: )
1774: and not exists
1775: (
1776: select 'x'
1777: from hr_organization_information hoi
1778: WHERE hoi.organization_id = paa.tax_unit_id
1779: and hoi.org_information_context ='1099R Magnetic Report Rules'
1780: )
1781: ORDER BY 1, 3, 4 DESC, 2 ;

Line 1810: FROM hr_organization_information hoi

1806: AND paf.effective_start_date <= ppa.effective_date
1807: AND paf.effective_end_date >= ppa.start_date
1808: AND not exists (
1809: SELECT 'x'
1810: FROM hr_organization_information hoi
1811: WHERE hoi.organization_id = paa.tax_unit_id
1812: and hoi.org_information_context = '1099R Magnetic Report Rules')
1813: ORDER BY 1, 3, 4 DESC, 2
1814: FOR UPDATE OF paf.assignment_id;

Line 1845: FROM hr_organization_information hoi

1841: AND paf.effective_start_date <= ppa.effective_date
1842: AND paf.effective_end_date >= ppa.start_date
1843: AND not exists (
1844: SELECT 'x'
1845: FROM hr_organization_information hoi
1846: WHERE hoi.organization_id = paa.tax_unit_id
1847: and hoi.org_information_context = '1099R Magnetic Report Rules')
1848: ORDER BY 1, 3, 4 DESC, 2
1849: FOR UPDATE OF paf.assignment_id;

Line 2516: SELECT org_information17 from hr_organization_information

2512: and hou.organization_id = paa.tax_unit_id;
2513:
2514: CURSOR c_get_pr_control_num ( cp_tax_unit_id number)
2515: IS
2516: SELECT org_information17 from hr_organization_information
2517: WHERE org_information_context = 'W2 Reporting Rules'
2518: AND organization_id = cp_tax_unit_id;
2519:
2520: CURSOR c_sit_check (cp_payroll_action_id number,