APPS.HZ_FUZZY_PUB dependencies on HZ_WORD_REPLACEMENTS

Line 181: FROM hz_word_replacements

177:
178: CURSOR C_Word_Rep (x_current_word VARCHAR2,
179: cp_wl_id NUMBER) IS
180: SELECT upper(replacement_word)
181: FROM hz_word_replacements
182: WHERE upper(original_word) = x_current_word
183: AND word_list_id = cp_wl_id
184: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
185: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')

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: )