APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on HZ_PARTY_SITES

Line 150: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;

146: BEGIN
147: DECLARE
148: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
149: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
150: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;
151: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
152: L_LOOKUP_TYPE VARCHAR2(20);
153: BEGIN
154: /*SRW.REFERENCE(C_SHIP_TO_SITE_USE_ID)*/NULL;

Line 162: HZ_PARTY_SITES PS,

158: ,HP.PERSON_TITLE) TITLE,
159: PS.ADDRESSEE
160: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE,L_ADDRESSEE
161: FROM
162: HZ_PARTY_SITES PS,
163: HZ_CUST_ACCT_SITES_ALL CA,
164: HZ_CUST_SITE_USES_ALL SU,
165: HZ_PARTIES HP
166: WHERE SU.SITE_USE_ID = C_SHIP_TO_SITE_USE_ID