APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_TRIP_STOPS

Line 13275: wsh_trip_stops s

13271: cursor c_get_trip_info(p_del_id in number) is
13272: select s.trip_id, d2.delivery_id
13273: from wsh_delivery_legs l1, wsh_delivery_legs l2,
13274: wsh_new_deliveries d1, wsh_new_deliveries d2,
13275: wsh_trip_stops s
13276: where l1.delivery_id = p_del_id
13277: and l1.delivery_id = d1.delivery_id -- bug 4891897
13278: and s.stop_id = l1.pick_up_stop_id
13279: and s.stop_location_id = d1.initial_pickup_location_id

Line 13304: FROM wsh_trip_stops s, wsh_delivery_legs l

13300: */
13301:
13302: CURSOR c_get_trip_id(p_delivery_id in number) IS
13303: SELECT trip_id
13304: FROM wsh_trip_stops s, wsh_delivery_legs l
13305: WHERE s.stop_id = l.pick_up_stop_id
13306: AND l.delivery_id = p_delivery_id;
13307:
13308: l_assign_flag VARCHAR2(1);