953: l_err_msg VARCHAR2(200);
954: rt_value Varchar2(150);
955: cursor get_value is
956: select tl.FLEX_VALUE_MEANING
957: from fnd_flex_values_tl tl,
958: fnd_flex_values val,
959: fnd_flex_value_sets valset
960: where tl.flex_value_id = val.flex_value_id
961: and tl.language = USERENV('LANG')
954: rt_value Varchar2(150);
955: cursor get_value is
956: select tl.FLEX_VALUE_MEANING
957: from fnd_flex_values_tl tl,
958: fnd_flex_values val,
959: fnd_flex_value_sets valset
960: where tl.flex_value_id = val.flex_value_id
961: and tl.language = USERENV('LANG')
962: and val.flex_value_set_id = valset.flex_value_set_id