The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT code_combination_id INTO l_template_line_ccid
FROM OKL_AE_TMPT_LNES
WHERE ID = p_ae_tmpt_line_id;
insert_if_new => TRUE,
ccid => l_ccid,
concat_segs => l_concat_segs,
concat_ids => l_concat_ids,
concat_descrs => l_concat_descrs,
error_message => l_err_msg,
new_combination => l_new_ccid);
SELECT code_combination_id INTO l_template_line_ccid
FROM OKL_AE_TMPT_LNES
WHERE ID = l_atl_id;