APPS.WSH_FTE_COMP_CONSTRAINT_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 108

     IF p_entity_tab(i).p_action_code <> G_ACTION_UPDATE THEN

        GOTO entity_nextpass;

Line: 160

       l_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_UPDATE_TRIP;

Line: 220

       l_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_UPDATE_DLVY;

Line: 372

SELECT
   wnd.ULTIMATE_DROPOFF_LOCATION_ID
FROM wsh_new_deliveries wnd
WHERE wnd.delivery_id = c_delivery_id;

Line: 378

SELECT
   wda.parent_delivery_id
FROM wsh_delivery_assignments wda
WHERE wda.delivery_id = c_delivery_id
AND TYPE= 'C';

Line: 385

SELECT
    wts.TRIP_ID, 'Y'as EXISTS_IN_DATABASE, wt. NAME, wt.PLANNED_FLAG, wt.STATUS_CODE,
    wt.VEHICLE_ITEM_ID, wt.VEHICLE_NUMBER, wt.CARRIER_ID, wt.SHIP_METHOD_CODE,
    wt.VEHICLE_ORGANIZATION_ID, wt.VEHICLE_NUM_PREFIX, wt.SERVICE_LEVEL, wt.MODE_OF_TRANSPORT
FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt
WHERE wdl.delivery_id = c_delivery_id
AND wdl.pick_up_stop_id = wts.stop_id
AND wts.trip_id = wt.trip_id;

Line: 520

                   l_delivery_info.DELETE;