select nvl(max(VALUE0), '0') into SF_QYBSDZFPJK from XT_YHCS00 a where a.NAME00 = 'SF_QYBSDZFPJK' and a.YGBH00 = ls_SFY000; if SF_QYBSDZFPJK = '1' then select count(*) into ls_count from SF_PJSYQK a where a.CZY000 = ls_SFY000 and a.JKDID0 = ls_JKDH00 and PLBH00 = '1' and a.PJXH00 ='0' and nvl(a.WBPJXH, '0') = '0'; if ls_count > 0 then as_YHMSG0:='存在未开具电子发票信息的发票记录,系统限制需要补开具以后才可以缴款!'; as_SYSMSG:='缴款提示'; rollback; return; end if; end if;