create or replace function sf_sf_getfzxmc
(
 pXZQH00 varchar2,
 pDQMC00 varchar2,
 pFZXMC0 varchar2,
 pGZZTMC varchar2
)
return  varchar2 is
  ls_FZXMC0   BM_DQFZX0.FZXMC0%TYPE;
-- MODIFICATION HISTORY
-- Person      Date        Comments
-- zhangyc     2011.04.22    created;
-- zhangyc     2011.04.28   增加入参pGZZTMC 农合病人(pGZZTMC='农民')
begin
 if (pGZZTMC='农民' or  pGZZTMC='城乡居民') then  ---农合病人根据行政区号查找分中心名称
  ls_FZXMC0:='';
  begin
  select  FZXMC0  into  ls_FZXMC0  from  BM_DQFZX0 where XZQH00= pXZQH00;
  exception
     when  others  then
           ls_FZXMC0:='';
  end;
 else  ---非农合病人直接返回医保中心名称
  ls_FZXMC0:=pFZXMC0;
 end if;
  return ls_FZXMC0;
end;