APPS.WSH_FTE_COMP_CONSTRAINT_PKG dependencies on WSH_NEW_DELIVERIES

Line 19: p_del_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,

15: p_init_msg_list IN VARCHAR2,
16: p_entity_type IN VARCHAR2,
17: p_target_id IN NUMBER,
18: p_action_code IN VARCHAR2,
19: p_del_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,
20: p_det_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
21: p_trip_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
22: p_stop_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
23: p_in_ids IN wsh_util_core.id_tab_type,

Line 106: FROM wsh_new_deliveries

102: SELECT NVL(shipping_control, 'BUYER'),
103: INITIAL_PICKUP_LOCATION_ID,
104: status_code,
105: shipment_direction
106: FROM wsh_new_deliveries
107: WHERE delivery_Id = l_delivery_id;
108:
109: cursor c_gettrip(l_deliveryid IN NUMBER) is
110: select wts.TRIP_ID

Line 117: from wsh_new_deliveries

113: wdl.pick_up_stop_id = wts.stop_id;
114:
115: cursor c_getdeliverytype(l_deliveryid IN NUMBER) is
116: select delivery_type
117: from wsh_new_deliveries
118: WHERE delivery_Id = l_deliveryid;
119:
120: cursor c_getdeliveryid(l_deldetailid IN NUMBER) is
121: select wda.delivery_id