create or replace function SF_JY_GETQTJHBH(
                                           ad_BRID00 number

                                           )
return varchar2 is
-- MODIFICATION HISTORY
-- Person      Date        Comments
-- wwq         2020.02.24  

   VRESULT   varchar2(500);
   V_CZYXM0  BM_YGBM00.ZWXM00%type;
   V_BRID00  SF_BRXXB0.BRID00%type;
   V_ICKH00  IC_YHXX00.ICKH00%type;
   LS_DDCZYXM  BM_YGBM00.ZWXM00%type;
   LS_DDCZY0  varchar2(10)   ;
   LS_DDCZJE   number(10,2);
   LS_ZYE000  SF_BRZHXX.ZYE000%type;
begin

   SELECT BRID00,substrb(qtjhbm,9,4) INTO V_BRID00,VRESULT FROM YS_QTJHXX WHERE brid00=ad_BRID00 and QTJHBZ='1' AND ROWNUM='1';
   return VRESULT;
exception
   when others   then
    VRESULT:='';
    return VRESULT;
end;