APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on PO_VENDOR_SITES_ALL

Line 636: FROM PO_VENDOR_SITES_ALL PVS,

632:
633: IF BILL_TO_SITE_ID IS NOT NULL THEN
634: SELECT HPS.LOCATION_ID
635: INTO BILL_TO_LOC_ID
636: FROM PO_VENDOR_SITES_ALL PVS,
637: HZ_PARTY_SITES HPS
638: WHERE PVS.VENDOR_SITE_ID = BILL_TO_SITE_ID
639: AND PVS.PARTY_SITE_ID = HPS.PARTY_SITE_ID;
640: END IF;

Line 1129: FROM PO_VENDOR_SITES_ALL PVS,

1125:
1126: IF BILL_TO_SITE_ID IS NOT NULL THEN
1127: SELECT HPS.LOCATION_ID
1128: INTO BILL_TO_LOC_ID
1129: FROM PO_VENDOR_SITES_ALL PVS,
1130: HZ_PARTY_SITES HPS
1131: WHERE PVS.VENDOR_SITE_ID = BILL_TO_SITE_ID
1132: AND PVS.PARTY_SITE_ID = HPS.PARTY_SITE_ID;
1133: END IF;