create or replace function ft_department(as_coopid char , as_department char) return varchar
is
  ls_departdesc varchar(150);
begin
	if as_coopid is null or as_department is null then
		return '';
	end if;
	select nvl( department_desc  , '' )
	into ls_departdesc
	from mbucfdepartment
	where coop_id = as_coopid
	and department_code = as_department;
	return trim(ls_departdesc);
end ;