CREATE OR REPLACE FUNCTION sf_sf_tyzd00
(
P_ZDMC00 in varchar2, --字典名称
P_BH0000 in varchar2,  --字典编码
P_MRZ000 in varchar2 default ''   --默认值
)
return varchar2 is
LS_ZDMC00 BM_TYZD00.ZDMC00%type;
LS_BH0000 BM_TYZD00.BH0000%type;
LS_FHXX00 BM_TYZD00.MC0000%type;
-- MODIFICATION HISTORY
--Person       Date        Comment
-- qks         2018.03.06  create：统一支付平台接口改造; for MZSF9-20180306-002
-- liwm        2019.09.02  长度不够 ZYSF9-20190806-001
-- zhangyc     2025.06.04  增加有效标志YXBZ00='1'  by MZSF9-20250604-002
begin
  LS_FHXX00:='';
if trim(P_ZDMC00) is not null and trim(P_BH0000) is not null then
 begin
   LS_ZDMC00:=P_ZDMC00;
   LS_BH0000:=P_BH0000;
   select trim(MC0000) into LS_FHXX00 from  BM_TYZD00 where ZDMC00=LS_ZDMC00 and  BH0000=LS_BH0000 and rownum=1 and nvl(YXBZ00,'1') in ('1');
 exception
    when others then
    LS_FHXX00:='';
 end;
end if;
 if trim(LS_FHXX00) is null and trim(P_MRZ000) is not null then
     LS_FHXX00:=P_MRZ000;
 end if;
 return trim(LS_FHXX00);
end;