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: --RTV changes
28: CURSOR GET_SUPPLIER IS
29: SELECT

Line 191: V_CUSTOMER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

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
194: SELECT
195: ACCOUNT_NUMBER

Line 197: HZ_CUST_ACCOUNTS

193: CURSOR GET_CUSTOMER IS
194: SELECT
195: ACCOUNT_NUMBER
196: FROM
197: HZ_CUST_ACCOUNTS
198: WHERE CUST_ACCOUNT_ID = V_CUST_ID;
199: --RTV changes
200: CURSOR GET_SUPPLIER IS
201: SELECT