CREATE OR REPLACE FUNCTION SF_YF_GETYPGWFL(PYPNM00 in number)
return varchar2 is
  C_GWYP        varchar2(4);
  v_Return      varchar2(180);
-- MODIFICATION HISTORY
-- Person      Date        Comments
-- DSM         2025.01.09 create for YF-20250106-001
begin
    begin
      select Trim(GWYPFL) into C_GWYP from BM_YD0000 where YPNM00=PYPNM00  ;
    exception
    when others then
      C_GWYP:='';
    end;
    if C_GWYP='1' then
       v_Return :='A类' ;
    elsif C_GWYP='2' then
       v_Return :='B类' ;
    elsif C_GWYP='3' then
       v_Return :='C类' ;
    end if;
    return v_Return;
end;