APPS.HZ_TRANS_PKG dependencies on HZ_WORD_LISTS

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 842: SELECT word_list_id FROM HZ_WORD_LISTS

838: p_language IN VARCHAR2)
839: RETURN VARCHAR2 IS
840:
841: CURSOR c_wl_id IS
842: SELECT word_list_id FROM HZ_WORD_LISTS
843: WHERE word_list_name = p_word_list_name ;
844:
845: l_wl_id NUMBER;
846: