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

Line 15: HR_ALL_ORGANIZATION_UNITS

11: CURSOR GET_ORG_NAME IS
12: SELECT
13: NAME
14: FROM
15: HR_ALL_ORGANIZATION_UNITS
16: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
17: X_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
18: V_SHIP_TO VARCHAR2(20) := NULL;
19: V_CUSTOMER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

Line 17: X_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;

13: NAME
14: FROM
15: HR_ALL_ORGANIZATION_UNITS
16: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
17: X_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
18: V_SHIP_TO VARCHAR2(20) := NULL;
19: V_CUSTOMER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
20: V_CUST_ID NUMBER;
21: CURSOR GET_CUSTOMER IS

Line 187: HR_ALL_ORGANIZATION_UNITS

183: CURSOR GET_ORG_NAME IS
184: SELECT
185: NAME
186: FROM
187: HR_ALL_ORGANIZATION_UNITS
188: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
189: X_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
190: V_SHIP_TO VARCHAR2(20) := NULL;
191: V_CUSTOMER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

Line 189: X_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;

185: NAME
186: FROM
187: HR_ALL_ORGANIZATION_UNITS
188: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
189: X_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
190: V_SHIP_TO VARCHAR2(20) := NULL;
191: V_CUSTOMER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
192: V_CUST_ID NUMBER;
193: CURSOR GET_CUSTOMER IS