APPS.AMS_LISTDEDUPE_PVT dependencies on HZ_WORD_REPLACEMENTS

Line 39: -- 01/02/2013 bchaturv Removed hardcoded replace of all special characters in word replacements. They are taken care by replacement words in HZ_WORD_REPLACEMENTS table.

35: -- 10/19/2000 vbhandar Made changes to dedupe_list to fix problem with dedup not working for more than 1 rank
36: -- 11/07/2000 vbhandar Made changes to dedupe_list to synchronize enabled flag with non deduped entries
37: -- 11/15/2000 vbhandar Made changes to filter word to do case insensitive comparison
38: -- 26/06/2001 gjoby changed the selection query - For Hornet
39: -- 01/02/2013 bchaturv Removed hardcoded replace of all special characters in word replacements. They are taken care by replacement words in HZ_WORD_REPLACEMENTS table.
40: --
41: -- End of Comments
42:
43: -- global constants

Line 921: FROM hz_word_replacements

917:
918: CURSOR C_Word_Rep (x_current_word VARCHAR2,
919: x_replacement_type VARCHAR2) IS
920: SELECT upper(replacement_word)
921: FROM hz_word_replacements
922: WHERE upper(original_word) = x_current_word
923: AND type = x_replacement_type;
924:
925: CURSOR c_key IS

Line 928: FROM HZ_WORD_REPLACEMENTS

924:
925: CURSOR c_key IS
926: SELECT ORIGINAL_WORD,
927: REPLACEMENT_WORD
928: FROM HZ_WORD_REPLACEMENTS
929: WHERE TYPE = 'KEY';
930:
931: BEGIN
932: