APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on HZ_PARTY_SITES

Line 157: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;

153: BEGIN
154: DECLARE
155: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
156: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
157: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;
158: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
159: L_LOOKUP_TYPE VARCHAR2(20);
160: BEGIN
161: /*SRW.REFERENCE(C_SHIP_TO_SITE_USE_ID)*/NULL;

Line 169: HZ_PARTY_SITES PS,

165: ,HP.PERSON_TITLE) TITLE,
166: PS.ADDRESSEE
167: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE,L_ADDRESSEE
168: FROM
169: HZ_PARTY_SITES PS,
170: HZ_CUST_ACCT_SITES_ALL CA,
171: HZ_CUST_SITE_USES_ALL SU,
172: HZ_PARTIES HP
173: WHERE SU.SITE_USE_ID = C_SHIP_TO_SITE_USE_ID