APPS.WSH_DELIVERY_LEGS_GRP dependencies on WSH_TRIPS

Line 35: FROM wsh_trips

31: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_LEG_ACTION';
32:
33: CURSOR get_trip_ship_method(p_trip_id NUMBER) IS
34: SELECT ship_method_code
35: FROM wsh_trips
36: WHERE trip_id=p_trip_id;
37:
38: CURSOR get_delivery_info( p_delivery_id IN NUMBER ) is
39: SELECT name,

Line 288: l_trip_name := wsh_trips_pvt.get_name(x_action_out_rec.x_trip_id);

284: FETCH get_trip_ship_method INTO l_ship_method_code;
285: CLOSE get_trip_ship_method;
286:
287: /*3301344 : Get the trip name from trip id */
288: l_trip_name := wsh_trips_pvt.get_name(x_action_out_rec.x_trip_id);
289:
290: IF (l_ship_method_code IS NULL ) THEN
291: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
292: /*3301344*/