493: in_system_id in number)
494: return varchar2 is
495: disp_name varchar2(80);
496: begin
497: -- get the display_name from wf_roles with constants in
498: -- in where condition.
499: select display_name
500: into disp_name
501: from wf_roles
497: -- get the display_name from wf_roles with constants in
498: -- in where condition.
499: select display_name
500: into disp_name
501: from wf_roles
502: where orig_system_id = in_system_id
503: and orig_system = in_system
504: and name = in_name;
505: