APPS.WSH_WSHRDINV_XMLP_PKG dependencies on HZ_PARTY_SITE_USES

Line 333: HZ_PARTY_SITE_USES PSU,

329: NVL(HP.PERSON_PRE_NAME_ADJUNCT
330: ,HP.PERSON_TITLE) TITLE
331: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
332: FROM
333: HZ_PARTY_SITE_USES PSU,
334: HZ_PARTY_SITES PS,
335: HZ_PARTIES HP
336: WHERE PSU.PARTY_SITE_USE_ID = SHIP_TO_SITE_USE_ID
337: AND PSU.SITE_USE_TYPE = 'PURCHASING'