The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT wcc.criterion_id
FROM wms_crossdock_criteria wcc
WHERE wcc.criterion_id = p_crt_id
AND wcc.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;
SELECT wccv.criterion_name
FROM wms_crossdock_criteria_vl wccv
WHERE wccv.criterion_id = p_crt_id
AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;
SELECT wccv.criterion_id
FROM wms_crossdock_criteria_vl wccv
WHERE wccv.criterion_name = p_crt_name
AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;
SELECT mtrh.header_id
, mtrh.move_order_type
FROM mtl_txn_request_lines mtrl
, mtl_txn_request_headers mtrh
WHERE mtrl.line_id = p_line_id
AND mtrh.header_id = mtrl.header_id;