create or replace function SF_JY_BGXMS0 ( PYBH000 in char, PPYRQ00 in char )return number is VCOUNT number; --Person Date comment --Nixj 2020.02.12 create for LIS9-20191119-001 begin select count(*) into VCOUNT from JY_JYJG00 where YBH000=PYBH000 and PYRQ00=PPYRQ00 and bgxmid not in ('999991','999992','999993','999994','999995','999996','999997','999998','999999'); return VCOUNT; end;