APPS.WSH_IB_UI_RECON_GRP dependencies on WSH_TRIPS

Line 30: from wsh_trips wt,

26: IS
27: --{
28: cursor l_trips_csr(p_shpmt_header_id NUMBER) is
29: select distinct wt.trip_id
30: from wsh_trips wt,
31: wsh_trip_stops wts,
32: wsh_delivery_legs wdl,
33: wsh_new_deliveries wnd
34: where wnd.RCV_SHIPMENT_HEADER_ID = p_shpmt_header_id

Line 79: update wsh_trips

75:
76: IF l_trip_id_tab.COUNT > 0 THEN
77: --{
78: FORALL i in l_trip_id_tab.FIRST..l_trip_id_tab.LAST
79: update wsh_trips
80: set status_code = 'IT'
81: where trip_id = l_trip_id_tab(i);
82: --}
83: END IF;