APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on HZ_PARTY_SITE_USES

Line 967: HZ_PARTY_SITE_USES PSU,

963: NVL(HP.PERSON_PRE_NAME_ADJUNCT
964: ,HP.PERSON_TITLE) TITLE
965: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
966: FROM
967: HZ_PARTY_SITE_USES PSU,
968: HZ_PARTY_SITES PS,
969: HZ_PARTIES HP
970: WHERE PSU.PARTY_SITE_USE_ID = SHP_TO_SITE_USE_ID
971: AND PSU.SITE_USE_TYPE = 'PURCHASING'