APPS.WSH_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_NEW_DELIVERIES

Line 66: SELECT name FROM wsh_new_deliveries

62: AND INTERFACE_ACTION_CODE ='94X_INBOUND';
63:
64: -- TPW - Distributed changes
65: CURSOR c_get_del_name (c_delivery_id IN NUMBER) IS
66: SELECT name FROM wsh_new_deliveries
67: WHERE delivery_id = c_delivery_id;
68:
69: CURSOR cont_not_recv_cur(l_delivery_id NUMBER, l_delivery_interface_id NUMBER) IS
70: SELECT wda.delivery_detail_id