APPS.HZ_FUZZY_PUB dependencies on HZ_TRANS_PKG

Line 184: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')

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')
186: )
187: AND condition_id IS NULL; --Bug No:4098780
188:

Line 185: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')

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')
186: )
187: AND condition_id IS NULL; --Bug No:4098780
188:
189: CURSOR c_key IS

Line 194: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND HWR.DELETE_FLAG = 'N')

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: )
197: AND HWR.CONDITION_ID IS NULL; --Bug No:4098780
198:

Line 195: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND HWR.STAGED_FLAG = 'Y')

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: )
197: AND HWR.CONDITION_ID IS NULL; --Bug No:4098780
198:
199: