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.WSMPINVL dependencies on HR_ORGANIZATION_UNITS

Line 2853: -- changed from org_organization_definitions to HR_ORGANIZATION_UNITS for bug 5051883

2849: -- Check if the organization is Still an enabled org in OOD.
2850:
2851: lProcLocation := 50;
2852: BEGIN
2853: -- changed from org_organization_definitions to HR_ORGANIZATION_UNITS for bug 5051883
2854: -- Performance issue on org_organization_definitions for full table scan on base tables
2855: -- SQL id 16641079
2856:
2857: SELECT 1

Line 2859: FROM HR_ORGANIZATION_UNITS

2855: -- SQL id 16641079
2856:
2857: SELECT 1
2858: into x_dummy
2859: FROM HR_ORGANIZATION_UNITS
2860: WHERE organization_id = x_organization_id
2861: and trunc(sysdate) <= nvl(date_to, sysdate + 1);
2862: --bug 5051883
2863: EXCEPTION when others THEN