The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT application_id
FROM fnd_application_vl
WHERE application_short_name = x_short_name;
SELECT msg.message_number
FROM fnd_new_messages msg, fnd_languages_vl lng
WHERE msg.message_name = x_msg
and msg.application_id = x_id
and lng.LANGUAGE_CODE = msg.language_code
and lng.language_id = x_lang_id;
SELECT okl_wf_item_s.nextval
FROM dual;
l_parameter_list.DELETE;
SELECT chrv.contract_number
FROM okc_k_headers_v chrv
WHERE chrv.id = p_contract_id;
SELECT *
FROM okl_trx_requests trx
WHERE trx.id = p_request_id;
SELECT *
FROM OKL_CONVERT_INT_RATE_REQUEST_V
WHERE TRQ_ID = p_request_id;
SELECT *
FROM OKL_K_RATE_PARAMS_V
WHERE KHR_ID = p_contract_id
AND EFFECTIVE_FROM_DATE = p_effective_date
AND PARAMETER_TYPE_CODE = p_parameter_type_code;
SELECT NAME
FROM OKL_INDICES
WHERE ID = p_index_id;
SELECT NAME
FROM OKL_FORMULAE_V
WHERE ID = p_formula_id;
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = p_lookup_type
AND lookup_code = p_lookup_code;
okl_trx_requests_pub.update_trx_requests(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trqv_rec => l_trq_rec,
x_trqv_rec => lx_trq_rec);