APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_WORD_FIELDS

Line 217: FROM ams_list_word_fields w

213: -- table and column name are the PK fields for this table.
214: CURSOR c_noise_words (my_field_table_name IN VARCHAR, my_field_column_name IN VARCHAR)
215: IS
216: SELECT w.original_word, w.replacement_word
217: FROM ams_list_word_fields w
218: WHERE w.field_table_name = my_field_table_name
219: AND w.field_column_name = my_field_column_name;
220:
221: l_original_word ams_list_word_fields.original_word%TYPE;

Line 221: l_original_word ams_list_word_fields.original_word%TYPE;

217: FROM ams_list_word_fields w
218: WHERE w.field_table_name = my_field_table_name
219: AND w.field_column_name = my_field_column_name;
220:
221: l_original_word ams_list_word_fields.original_word%TYPE;
222: l_replacement_word ams_list_word_fields.replacement_word%TYPE;
223: l_word VARCHAR2(500);
224:
225: BEGIN

Line 222: l_replacement_word ams_list_word_fields.replacement_word%TYPE;

218: WHERE w.field_table_name = my_field_table_name
219: AND w.field_column_name = my_field_column_name;
220:
221: l_original_word ams_list_word_fields.original_word%TYPE;
222: l_replacement_word ams_list_word_fields.replacement_word%TYPE;
223: l_word VARCHAR2(500);
224:
225: BEGIN
226: --we always compare in uppercase.