CREATE OR REPLACE FUNCTION SF_YF_GETMZCFSHR(PCFLSH0 in char)
return varchar2 is
  ls_CFLSH0  YF_MZCF00.CFLSH0%type;
  ls_SHR000  BM_YGBM00.YGBH00%type;
  ls_ZWXM00  BM_YGBM00.ZWXM00%type;
  ls_SHRQ00  YF_MZCF00.SHRQ00%type;
-- MODIFICATION HISTORY
-- Person      Date        Comments
-- dsm         2025.01.15  create for YF-20250106-007
-- dsm         2025.07.23  审方人为空时取FYR000 for YF-20250721-001
begin
   ls_CFLSH0:=PCFLSH0;
   select nvl(SFR000,FYR000) SFR000,SHRQ00 into ls_SHR000,ls_SHRQ00 from YF_MZCF00 where CFLSH0=ls_CFLSH0;
   select ZWXM00 into ls_ZWXM00 from BM_YGBM00 where YGBH00=nvl(ls_SHR000,0);
   if ls_SHRQ00 is null then
     ls_ZWXM00:='';
   end if;
   return ls_ZWXM00;
exception
  when others then
    return '';
end;