DBA Data[Home] [Help]

APPS.HZ_WORD_ARRAY_PKG dependencies on HZ_WORD_REPLACEMENTS

Line 32: FROM HZ_WORD_REPLACEMENTS

28:
29: -- Populate word list array with global replacements first
30: FOR indx IN (
31: SELECT original_word, replacement_word
32: FROM HZ_WORD_REPLACEMENTS
33: WHERE word_list_id = wl_id and nvl(condition_id, 0) = 0
34: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
35: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')
36: )

Line 48: FROM HZ_WORD_REPLACEMENTS

44: -- Here we just mark the original word as dirty
45:
46: FOR indx IN (
47: SELECT distinct original_word
48: FROM HZ_WORD_REPLACEMENTS
49: WHERE word_list_id = wl_id and condition_id > 0
50: AND ((HZ_TRANS_PKG.staging_context = 'Y' AND DELETE_FLAG = 'N')
51: OR (nvl(HZ_TRANS_PKG.staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')
52: )