173: if (tvalue is null) then
174: begin
175: SELECT name
176: INTO tvalue
177: FROM wf_role_lov_vl
178: WHERE upper(display_name) = upper(p_from_role)
179: AND rownum = 1;
180: exception
181: when no_data_found then