APPS.WSH_FTE_COMP_CONSTRAINT_PKG dependencies on WSH_TRIPS

Line 21: p_trip_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

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,
24: p_pickup_stop_id IN NUMBER DEFAULT NULL,
25: p_pickup_loc_id IN NUMBER DEFAULT NULL,

Line 824: FROM wsh_trips

820: , VEHICLE_ORGANIZATION_ID
821: , VEHICLE_NUM_PREFIX
822: , SERVICE_LEVEL
823: , MODE_OF_TRANSPORT
824: FROM wsh_trips
825: WHERE trip_id = c_trip_id;
826:
827: CURSOR c_get_parent_delivery_leg(c_del_id NUMBER, c_del_leg_id NUMBER) IS
828: SELECT PARENT_DELIVERY_LEG_ID