The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT a.ship_method_code
FROM wsh_carrier_services a, wsh_org_carrier_services b
WHERE a.carrier_service_id = b.carrier_service_id
AND b.organization_id = c_org_id
AND b.enabled_flag = 'Y'
AND a.enabled_flag = 'Y'
AND a.mode_of_transport = c_mode_of_trans
AND a.service_level = c_service_level
AND a.carrier_id = c_carrier_id;
SELECT freight_code
FROM wsh_carriers
WHERE carrier_id = c_carrier_id;
SELECT generic_flag
FROM wsh_carriers
WHERE carrier_id = c_carrier_id;
SELECT a.generic_flag
FROM wsh_carriers a, wsh_carrier_services b
WHERE a.carrier_id = b.carrier_id
AND b.ship_method_code = c_ship_method_code;
SELECT ship_method_code,carrier_id, service_level, mode_of_transport, ship_method_meaning
FROM wsh_carrier_services
WHERE ship_method_code = c_shp_mthd_cd;
fte_freight_pricing.g_shipment_line_rows.DELETE;
l_values_tab.DELETE;
l_lane_info_tab.DELETE;
SELECT fte_pricing_comp_request_s.nextval
FROM sys.dual;
l_lane_info_tab.DELETE;
l_tl_source_header_rates_tab.delete;
l_tl_source_line_rates_tab.delete;