APPS.WSH_FTE_COMP_CONSTRAINT_PKG SQL Statements

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

Line: 96

    SELECT NVL(shipping_control,'BUYER'), ship_from_location_id,
           line_direction, released_status
    FROM wsh_delivery_details
    WHERE delivery_detail_Id = l_detail_id;

Line: 102

    SELECT NVL(shipping_control, 'BUYER'),
           INITIAL_PICKUP_LOCATION_ID,
           status_code,
           shipment_direction
    FROM wsh_new_deliveries
    WHERE delivery_Id = l_delivery_id;

Line: 110

    select wts.TRIP_ID
    from wsh_trip_stops wts, wsh_delivery_legs wdl
    where wdl.delivery_id =l_deliveryid AND
    wdl.pick_up_stop_id = wts.stop_id;

Line: 116

    select delivery_type
    from wsh_new_deliveries
    WHERE delivery_Id = l_deliveryid;

Line: 121

    select wda.delivery_id
    from wsh_delivery_assignments_v wda
    where wda.delivery_detail_id=l_deldetailid;

Line: 127

    select compatibility_id
    from   wsh_fte_comp_constraints
    where  EFFECTIVE_DATE_FROM <= sysdate
    and    nvl(EFFECTIVE_DATE_TO,sysdate) >= sysdate
    and    rownum = 1;

Line: 239

	IF p_action_code = 'UPDATE' THEN
		l_cc_action_code:='UPD';

Line: 254

	ELSIF p_action_code = 'SELECT-CARRIER' THEN
		l_cc_action_code:='ACS';

Line: 418

   	--following check for update deldetail is not needed as of now
	IF p_action_code='UPDATE' THEN
		l_cc_action_code:='UPD';

Line: 560

	IF p_action_code ='UPDATE' THEN
	   l_cc_action_code:='UPT';

Line: 619

	IF p_action_code ='UPDATE' THEN
		l_cc_action_code:='UPS';

Line: 621

	ELSIF p_action_code ='DELETE' THEN
		l_cc_action_code:='DTS';

Line: 811

    SELECT TRIP_ID
     , 'Y'
     , NAME
     , PLANNED_FLAG
     , STATUS_CODE
     , VEHICLE_ITEM_ID
     , VEHICLE_NUMBER
     , CARRIER_ID
     , SHIP_METHOD_CODE
     , VEHICLE_ORGANIZATION_ID
     , VEHICLE_NUM_PREFIX
     , SERVICE_LEVEL
     , MODE_OF_TRANSPORT
    FROM wsh_trips
    WHERE trip_id = c_trip_id;

Line: 828

    SELECT PARENT_DELIVERY_LEG_ID
    FROM wsh_delivery_legs
    WHERE DELIVERY_LEG_ID = c_del_leg_id
    AND DELIVERY_ID = c_del_id;