APPS.WSH_WSHRDOPN_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 19: V_CUSTOMER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

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
22: SELECT
23: ACCOUNT_NUMBER

Line 25: HZ_CUST_ACCOUNTS

21: CURSOR GET_CUSTOMER IS
22: SELECT
23: ACCOUNT_NUMBER
24: FROM
25: HZ_CUST_ACCOUNTS
26: WHERE CUST_ACCOUNT_ID = V_CUST_ID;
27: V_SHIP FND_LOOKUP_VALUES_VL.LOOKUP_CODE%TYPE;
28: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;
29: CURSOR GET_ITEM_DISP_MEANING IS

Line 172: V_CUSTOMER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

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
175: SELECT
176: ACCOUNT_NUMBER

Line 178: HZ_CUST_ACCOUNTS

174: CURSOR GET_CUSTOMER IS
175: SELECT
176: ACCOUNT_NUMBER
177: FROM
178: HZ_CUST_ACCOUNTS
179: WHERE CUST_ACCOUNT_ID = V_CUST_ID;
180: V_SHIP FND_LOOKUP_VALUES_VL.LOOKUP_CODE%TYPE;
181: V_ITEM_DISPLAY WSH_LOOKUPS.MEANING%TYPE;
182: CURSOR GET_ITEM_DISP_MEANING IS