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