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.PER_US_IPEDS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 253: FROM hr_all_organization_units hou

249: AND asg.job_id = job.job_id
250: AND asg.assignment_type = 'E'
251: AND peo.business_group_id = p_business_group_id
252: AND EXISTS (SELECT 'Y'
253: FROM hr_all_organization_units hou
254: WHERE hou.business_group_id = p_business_group_id
255: AND hou.organization_id = asg.organization_id)
256: )
257: GROUP BY DECODE(tenure_status,'01',tenure_status,'02')

Line 384: FROM hr_all_organization_units hou

380: AND pst.business_group_id IS NULL
381: AND pst1.business_group_id(+) = p_business_group_id
382: AND NVL(pst1.information1,pst.information1) = 'Y'
383: AND EXISTS (SELECT 'Y'
384: FROM hr_all_organization_units hou
385: WHERE hou.business_group_id = p_business_group_id
386: AND hou.organization_id = asg.organization_id)
387: )
388: GROUP BY '03'||DECODE(SIGN(cont_dur_mon-12),1,0,0,1,2)

Line 489: FROM hr_all_organization_units hou

485: AND asg.job_id = job.job_id
486: AND asg.assignment_type = 'E'
487: AND peo.business_group_id = p_business_group_id
488: AND EXISTS (SELECT 'Y'
489: FROM hr_all_organization_units hou
490: WHERE hou.business_group_id = p_business_group_id
491: AND hou.organization_id = asg.organization_id)
492: AND NOT EXISTS (SELECT 'Y'
493: FROM per_people_extra_info ppet

Line 621: FROM hr_all_organization_units hou

617: AND pst.business_group_id IS NULL
618: AND pst1.business_group_id(+) = p_business_group_id
619: AND NVL(pst1.information1,pst.information1) = 'Y'
620: AND EXISTS (SELECT 'Y'
621: FROM hr_all_organization_units hou
622: WHERE hou.business_group_id = p_business_group_id
623: AND hou.organization_id = asg.organization_id)
624: )
625: GROUP BY '03'||DECODE(SIGN(cont_dur_mon-12),1,0,0,1,2)

Line 725: FROM hr_all_organization_units hou

721: AND asg.job_id = job.job_id
722: AND asg.assignment_type = 'E'
723: AND peo.business_group_id = p_business_group_id
724: AND EXISTS (SELECT 'Y'
725: FROM hr_all_organization_units hou
726: WHERE hou.business_group_id = p_business_group_id
727: AND hou.organization_id = asg.organization_id)
728: AND NOT EXISTS (SELECT 'Y'
729: FROM per_contracts_f pco

Line 879: FROM hr_all_organization_units hou

875: AND asg.job_id = job.job_id
876: AND asg.assignment_type = 'E'
877: AND peo.business_group_id = p_business_group_id
878: AND EXISTS (SELECT 'Y'
879: FROM hr_all_organization_units hou
880: WHERE hou.business_group_id = p_business_group_id
881: AND hou.organization_id = asg.organization_id)
882: )
883: GROUP BY DECODE(tenure_status,'01',tenure_status,'02')

Line 1001: FROM hr_all_organization_units hou

997: AND pst.business_group_id is null
998: AND pst1.business_group_id(+) = p_business_group_id
999: AND nvl(pst1.information1,pst.information1) = 'Y'
1000: AND EXISTS (SELECT 'Y'
1001: FROM hr_all_organization_units hou
1002: WHERE hou.business_group_id = p_business_group_id
1003: AND hou.organization_id = asg.organization_id)
1004: )
1005: GROUP BY '03'||DECODE(SIGN(cont_dur_mon-12),1,0,0,1,2)

Line 1102: FROM hr_all_organization_units hou

1098: AND asg.job_id = job.job_id
1099: AND asg.assignment_type = 'E'
1100: AND peo.business_group_id = p_business_group_id
1101: AND EXISTS (SELECT 'Y'
1102: FROM hr_all_organization_units hou
1103: WHERE hou.business_group_id = p_business_group_id
1104: AND hou.organization_id = asg.organization_id)
1105: AND NOT EXISTS( SELECT 'Y'
1106: FROM per_people_extra_info ppet

Line 1226: FROM hr_all_organization_units hou

1222: AND pst.business_group_id is null
1223: AND pst1.business_group_id(+) = p_business_group_id
1224: AND nvl(pst1.information1,pst.information1) = 'Y'
1225: AND EXISTS (SELECT 'Y'
1226: FROM hr_all_organization_units hou
1227: WHERE hou.business_group_id = p_business_group_id
1228: AND hou.organization_id = asg.organization_id)
1229: )
1230: GROUP BY '03'||DECODE(SIGN(cont_dur_mon-12),1,0,0,1,2)

Line 1328: FROM hr_all_organization_units hou

1324: AND asg.job_id = job.job_id
1325: AND asg.assignment_type = 'E'
1326: AND peo.business_group_id = p_business_group_id
1327: AND EXISTS (SELECT 'Y'
1328: FROM hr_all_organization_units hou
1329: WHERE hou.business_group_id = p_business_group_id
1330: AND hou.organization_id = asg.organization_id)
1331: AND NOT EXISTS( SELECT 'Y'
1332: FROM per_contracts_f pco

Line 1455: FROM hr_all_organization_units hou

1451: AND asg.job_id = job.job_id
1452: AND asg.assignment_type = 'E'
1453: AND peo.business_group_id = p_business_group_id
1454: AND EXISTS (SELECT 'Y'
1455: FROM hr_all_organization_units hou
1456: WHERE hou.business_group_id = p_business_group_id
1457: AND hou.organization_id = asg.organization_id)
1458: )
1459: GROUP BY DECODE(ipeds_code,21,21,22,21,23,21,24,21,ipeds_code);

Line 1576: FROM hr_all_organization_units hou

1572: AND pst.business_group_id IS NULL
1573: AND pst1.business_group_id(+) = p_business_group_id
1574: AND NVL(pst1.information1,pst.information1) = 'Y'
1575: AND EXISTS (SELECT 'Y'
1576: FROM hr_all_organization_units hou
1577: WHERE hou.business_group_id = p_business_group_id
1578: AND hou.organization_id = asg.organization_id)
1579: )
1580: GROUP BY academic_rank;

Line 1628: FROM hr_all_organization_units hou

1624: AND asg.job_id = job.job_id
1625: AND asg.assignment_type = 'E'
1626: AND peo.business_group_id = p_business_group_id
1627: AND EXISTS (SELECT 'Y'
1628: FROM hr_all_organization_units hou
1629: WHERE hou.business_group_id = p_business_group_id
1630: AND hou.organization_id = asg.organization_id)
1631: GROUP BY DECODE(job.job_information8,28,27,29,27,30,27,job.job_information8);
1632:

Line 1760: FROM hr_all_organization_units hou

1756: AND asg.period_of_service_id = pps.period_of_service_id
1757: AND pps.date_start BETWEEN ADD_MONTHS(p_report_date,-4) AND (p_report_date-1)
1758: AND peo.business_group_id = p_business_group_id
1759: AND EXISTS (SELECT 'Y'
1760: FROM hr_all_organization_units hou
1761: WHERE hou.business_group_id = p_business_group_id
1762: AND hou.organization_id = asg.organization_id)
1763: )
1764: GROUP BY DECODE(tenure_status,'01',tenure_status,'02')

Line 1884: FROM hr_all_organization_units hou

1880: AND pst.business_group_id IS NULL
1881: AND pst1.business_group_id(+) = p_business_group_id
1882: AND NVL(pst1.information1,pst.information1) = 'Y'
1883: AND EXISTS (SELECT 'Y'
1884: FROM hr_all_organization_units hou
1885: WHERE hou.business_group_id = p_business_group_id
1886: AND hou.organization_id = asg.organization_id)
1887: )
1888: GROUP BY '03'||DECODE(SIGN(cont_dur_mon-12),1,0,0,1,2)

Line 1988: FROM hr_all_organization_units hou

1984: AND peo.business_group_id = p_business_group_id
1985: AND asg.period_of_service_id = pps.period_of_service_id
1986: AND pps.date_start BETWEEN ADD_MONTHS(p_report_date,-4) AND (p_report_date-1)
1987: AND EXISTS (SELECT 'Y'
1988: FROM hr_all_organization_units hou
1989: WHERE hou.business_group_id = p_business_group_id
1990: AND hou.organization_id = asg.organization_id)
1991: AND NOT EXISTS (SELECT 'Y'
1992: FROM per_people_extra_info ppet

Line 2113: FROM hr_all_organization_units hou

2109: AND pst.business_group_id IS NULL
2110: AND pst1.business_group_id(+) = p_business_group_id
2111: AND NVL(pst1.information1,pst.information1) = 'Y'
2112: AND EXISTS (SELECT 'Y'
2113: FROM hr_all_organization_units hou
2114: WHERE hou.business_group_id = p_business_group_id
2115: AND hou.organization_id = asg.organization_id)
2116: )
2117: GROUP BY '03'||DECODE(SIGN(cont_dur_mon-12),1,0,0,1,2)

Line 2216: FROM hr_all_organization_units hou

2212: AND peo.business_group_id = p_business_group_id
2213: AND asg.period_of_service_id = pps.period_of_service_id
2214: AND pps.date_start BETWEEN ADD_MONTHS(p_report_date,-4) AND (p_report_date-1)
2215: AND EXISTS (SELECT 'Y'
2216: FROM hr_all_organization_units hou
2217: WHERE hou.business_group_id = p_business_group_id
2218: AND hou.organization_id = asg.organization_id)
2219: AND NOT EXISTS (SELECT 'Y'
2220: FROM per_contracts_f pco

Line 2323: FROM hr_all_organization_units hou

2319: AND peo.business_group_id = p_business_group_id
2320: AND asg.period_of_service_id = pps.period_of_service_id
2321: AND pps.date_start BETWEEN ADD_MONTHS(p_report_date,-4) AND (p_report_date-1)
2322: AND EXISTS (SELECT 'Y'
2323: FROM hr_all_organization_units hou
2324: WHERE hou.business_group_id = p_business_group_id
2325: AND hou.organization_id = asg.organization_id)
2326: )
2327: GROUP BY ipeds_category;

Line 2455: FROM hr_all_organization_units hou

2451: AND asg.job_id = job.job_id
2452: AND asg.assignment_type = 'E'
2453: AND peo.business_group_id = p_business_group_id
2454: AND EXISTS (SELECT 'Y'
2455: FROM hr_all_organization_units hou
2456: WHERE hou.business_group_id = p_business_group_id
2457: AND hou.organization_id = asg.organization_id))
2458: GROUP BY ipeds_category;
2459: