prompt 24、得到新农合投保人所属区号对应的投保中心名称  SF_SF_GETFZXMC;
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='农民')
-- liwm        2018.07.12   适配城乡居民 for ZYSF9-20180528-003 
-- qks         2020.05.18   优先根据BM_DQFZX0.DQMC00进行适配获取ls_FZXMC0
begin
 if (pGZZTMC='农民' or  pGZZTMC='城乡居民')  then  ---农合病人根据行政区号查找分中心名称
  ls_FZXMC0:='';
  begin
  	if pDQMC00 is not null then
  	  select max(FZXMC0) into ls_FZXMC0 from BM_DQFZX0 where DQMC00= pDQMC00;
    end if;
  	if ls_FZXMC0 is null then
      select  FZXMC0  into  ls_FZXMC0  from  BM_DQFZX0 where XZQH00= pXZQH00;
    end if;  
  exception
     when  others  then
           ls_FZXMC0:='';    
  end;
 else  ---非农合病人直接返回医保中心名称
  ls_FZXMC0:=pFZXMC0; 
 end if; 
  return ls_FZXMC0;
end;
/
show error;
--%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%