APPS.WSH_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_NEW_DELIVERIES

Line 264: update wsh_new_deliveries

260: -- Need to update the delivery status to SA
261: -- 2394893. This change has been made as a part of this bug because of
262: -- the change made in the API Update_Dlvy_Status ( Autonomous Transaction ).
263:
264: update wsh_new_deliveries
265: set status_code ='SA'
266: where delivery_id = l_delivery_id
267: and status_code IN ('SR','SC');
268: