CREATE OR REPLACE FUNCTION SF_YF_YTYYSBZ
(
   PYFBMBH   number,
   PBQBMBH   number,
   PYPNM00   number
)
return number
is
-- modification history
-- Person      Date        Comments
-- luowf       2024.11.28  create YF13-20241122-003
----------------------------------------------------------
  resultNum number(3);
  vDQRQ00  YF_KSDKMX.CZRQ00%type;   --当前日期
  vYTRQ00  YF_KSDKMX.CZRQ00%type;   --最大预退日期+3
  vDKGHRQ  YF_KSDKMX.CZRQ00%type;   --抵扣归还日期
  --1号预退，2号一天3号一天4号一天，5号提醒
begin
  select to_char(to_date(nvl(max(CZRQ00),'20991231'),'YYYYMMDD')+3,'YYYYMMDD') into vYTRQ00 from YF_KSDKMX where YFBMBH=PYFBMBH and BQBMBH=PBQBMBH and YPNM00=PYPNM00 and JZXZ00='R';
  vDQRQ00 := to_char(sysdate,'YYYYMMDD');
  if vDQRQ00>vYTRQ00 then    --预退日期+3小于当前日期，可能要标红
     --再判断当前日期-3有没有抵扣或归还，有就不标，否则标红
     select to_char(to_date(nvl(max(CZRQ00),'20991231'),'YYYYMMDD'),'YYYYMMDD') into vDKGHRQ
       from YF_KSDKMX where YFBMBH=PYFBMBH and BQBMBH=PBQBMBH and YPNM00=PYPNM00 and JZXZ00='C' and CZRQ00>=to_char(sysdate-3,'YYYYMMDD');
     if vDKGHRQ = '20991231' then
        return 0;
     end if;
  end if;
  return 1;
end;