APPS.WSH_DSNO dependencies on WSH_TRIPS

Line 236: WSH_TRIPS WTP,

232: cursor c_dsno_deliveries(c_trip_stop_id number ) is
233: SELECT
234: DECODE(HCAS.ORG_ID,WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(wnd.delivery_id),1,NULL,1, NULL) record_exists
235: FROM WSH_TRIP_STOPS WTS,
236: WSH_TRIPS WTP,
237: WSH_TRIP_STOPS WTS2,
238: WSH_DELIVERY_LEGS WDL,
239: WSH_NEW_DELIVERIES WND,
240: WSH_LOCATIONS WSHL,