APPS.FTE_WSH_INTERFACE_PKG dependencies on WSH_NEW_DELIVERIES

Line 1175: FROM wsh_new_deliveries dl,

1171: --
1172: CURSOR pickup_deliveries_cur (p_stop_id NUMBER) IS
1173: SELECT
1174: dg.delivery_id, dl.name
1175: FROM wsh_new_deliveries dl,
1176: wsh_delivery_legs dg,
1177: wsh_trip_stops st
1178: WHERE dg.delivery_id = dl.delivery_id
1179: AND st.stop_location_id = dl.initial_pickup_location_id

Line 2983: FROM WSH_NEW_DELIVERIES

2979: THEN
2980: BEGIN
2981:
2982: SELECT ORGANIZATION_ID INTO X_ORGANIZATION_ID
2983: FROM WSH_NEW_DELIVERIES
2984: WHERE DELIVERY_ID = p_entity_id;
2985:
2986: IF (SQL%NOTFOUND) THEN
2987: RAISE NO_DATA_FOUND;