APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_WORD_FIELDS

Line 218: FROM ams_list_word_fields w

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

Line 222: l_original_word ams_list_word_fields.original_word%TYPE;

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

Line 223: l_replacement_word ams_list_word_fields.replacement_word%TYPE;

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