896: l_err_msg VARCHAR2(200);
897: rt_value Varchar2(150);
898: cursor get_value is
899: select tl.FLEX_VALUE_MEANING
900: from fnd_flex_values_tl tl,
901: fnd_flex_values val,
902: fnd_flex_value_sets valset
903: where tl.flex_value_id = val.flex_value_id
904: and tl.language = USERENV('LANG')
897: rt_value Varchar2(150);
898: cursor get_value is
899: select tl.FLEX_VALUE_MEANING
900: from fnd_flex_values_tl tl,
901: fnd_flex_values val,
902: fnd_flex_value_sets valset
903: where tl.flex_value_id = val.flex_value_id
904: and tl.language = USERENV('LANG')
905: and val.flex_value_set_id = valset.flex_value_set_id