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 168: HR_ALL_ORGANIZATION_UNITS

164: CURSOR GET_ORG_NAME IS
165: SELECT
166: NAME
167: FROM
168: HR_ALL_ORGANIZATION_UNITS
169: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
170: X_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
171: V_SHIP_TO VARCHAR2(20) := NULL;
172: V_CUSTOMER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

Line 170: X_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;

166: NAME
167: FROM
168: HR_ALL_ORGANIZATION_UNITS
169: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
170: X_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
171: V_SHIP_TO VARCHAR2(20) := NULL;
172: V_CUSTOMER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
173: V_CUST_ID NUMBER;
174: CURSOR GET_CUSTOMER IS