APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 164: HZ_CUST_SITE_USES_ALL SU,

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
167: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
168: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID