APPS.HZ_FUZZY_PUB dependencies on HZ_WORD_LISTS

Line 175: SELECT word_list_id FROM HZ_WORD_LISTS

171: l_exit_flag VARCHAR2(1) := 'N';
172:
173:
174: CURSOR c_wl_id (c_word_list_name VARCHAR2) IS
175: SELECT word_list_id FROM HZ_WORD_LISTS
176: WHERE word_list_name = c_word_list_name;
177:
178: CURSOR C_Word_Rep (x_current_word VARCHAR2,
179: cp_wl_id NUMBER) IS

Line 192: FROM HZ_WORD_LISTS HWL, HZ_WORD_REPLACEMENTS HWR

188:
189: CURSOR c_key IS
190: SELECT HWR.ORIGINAL_WORD,
191: HWR.REPLACEMENT_WORD
192: FROM HZ_WORD_LISTS HWL, HZ_WORD_REPLACEMENTS HWR
193: WHERE HWL.WORD_LIST_NAME = 'KEY MODIFIERS' AND HWR.WORD_LIST_ID = HWL.WORD_LIST_ID
194: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND HWR.DELETE_FLAG = 'N')
195: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND HWR.STAGED_FLAG = 'Y')
196: )