APPS.HZ_TRANS_PKG dependencies on HZ_WORD_REPLACEMENTS

Line 296: from hz_word_replacements WR1, hz_word_lists WL1

292: FOR wr_cur in
293: (
294: select WR1.original_word as org_w , WR1.replacement_word as rep_w,
295: WR1.user_spec_cond_value, WR1.condition_id
296: from hz_word_replacements WR1, hz_word_lists WL1
297: where WL1.word_list_id = wr_list_id
298: and WL1.word_list_id = WR1.word_list_id
299: and WR1.original_word like starting_char and instr( in_str, WR1.original_word) = 1
300: and ( ( staging_context = 'Y' and WR1.delete_flag = 'N')

Line 386: FROM HZ_WORD_REPLACEMENTS

382:
383: CURSOR c_wl_repl_string(cp_wl_id NUMBER, cp_orig_word
384: VARCHAR2, cp_replacement_range VARCHAR2 ) IS
385: SELECT replacement_word, condition_id, user_spec_cond_value
386: FROM HZ_WORD_REPLACEMENTS
387: WHERE WORD_LIST_ID = cp_wl_id
388: AND ORIGINAL_WORD = cp_orig_word
389: AND ((staging_context = 'Y' AND DELETE_FLAG = 'N')
390: OR (nvl(staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')

Line 572: FROM HZ_WORD_REPLACEMENTS

568:
569: CURSOR c_wl_repl_string(cp_wl_id NUMBER, cp_orig_word
570: VARCHAR2, cp_replacement_range VARCHAR2 ) IS
571: SELECT replacement_word, condition_id, user_spec_cond_value
572: FROM HZ_WORD_REPLACEMENTS
573: WHERE WORD_LIST_ID = cp_wl_id
574: AND ORIGINAL_WORD = cp_orig_word
575: AND ((staging_context = 'Y' AND DELETE_FLAG = 'N')
576: OR (nvl(staging_context,'N') = 'N' AND STAGED_FLAG = 'Y')