APPS.HZ_WORD_ARRAY_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

   select nvl(non_delimited_flag,'N') into flag
   from hz_word_lists
   where word_list_id = wl_id ;

Line: 31

     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 ;

Line: 47

     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' ;