The following lines contain the word 'select', 'insert', 'update' or 'delete':
select application_id,
estimated_amount,
buy_or_sell,
orig_system_source_code
from okc_k_headers_b
where id = p_chr_id;
SELECT hdr.orig_system_source_code, cle.ID
FROM OKC_K_LINES_B cle,
OKC_K_HEADERS_B hdr
WHERE hdr.id = p_chr_id
AND hdr.id = cle.dnz_chr_id (+)
AND ROWNUM < 2;
OKC_Price_Pub.Update_Contract_Price(
p_api_version => 1.0,
p_init_msg_list => OKC_API.G_FALSE,
p_commit => OKC_API.G_FALSE,
p_chr_id => p_chr_id,
px_control_rec => l_control_rec,
x_cle_price_tbl => l_cle_price_tbl,
x_chr_net_price => l_chr_net_price,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
select application_id,
buy_or_sell,
orig_system_source_code
from okc_k_headers_b
where id = p_chr_id;
SELECT hdr.orig_system_source_code, cle.ID
FROM OKC_K_LINES_B cle,
OKC_K_HEADERS_B hdr
WHERE hdr.id = p_chr_id
AND hdr.id = cle.dnz_chr_id (+)
AND ROWNUM < 2;
SELECT object1_id1, number_of_items qty
FROM okc_k_items
WHERE cle_id = b_cle_id
AND dnz_chr_id = p_chr_id
AND jtot_object1_code = 'OKX_COVLINE';
SELECT number_of_items qty
FROM okc_k_items
WHERE cle_id = b_cle_id
AND dnz_chr_id = p_chr_id;
SELECT cle_id, id, line_number, lse_id
BULK COLLECT INTO l_cle_id_tbl,l_id_tbl, l_line_number_tbl, l_lse_id_tbl
FROM okc_k_lines_b
CONNECT BY PRIOR id = cle_id
START WITH chr_id = p_chr_id;
okc_debug.Log('1060 : select rowcount'||SQL%ROWCOUNT, 1);