create or replace FuncTion ft_getgrpname( as_coopid char , as_memgrp char ) return varchar2
is
ls_memgrpdesc varchar2(150);
begin
	if as_coopid is null or as_memgrp is null then
		return '';
	end if;
	select nvl( membgroup_desc , '' )
	into ls_memgrpdesc
	from mbucfmembgroup 
	where coop_id = as_coopid 
	and membgroup_code = as_memgrp;
	return trim(ls_memgrpdesc);
end ;
/
