The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl(non_delimited_flag,'N') into flag
from hz_word_lists
where word_list_id = wl_id ;
SELECT original_word, replacement_word
FROM HZ_WORD_REPLACEMENTS
WHERE word_list_id = wl_id and nvl(condition_id, 0) = 0
AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')
)
)
LOOP
word_list_global_rep_lookup(wl_id)(indx.original_word) := indx.replacement_word ;
SELECT distinct original_word
FROM HZ_WORD_REPLACEMENTS
WHERE word_list_id = wl_id and condition_id > 0
AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')
)
order by original_word )
LOOP
word_list_global_rep_lookup(wl_id)(indx.original_word) := '-1' ;