AAA

create or replace function FBH_PKTTN_BPHI_SO_ID
(b_gt number,b_so_nguoi number,b_nt_tien varchar2,b_ngay_hl number:=0) return number
AS
b_so_id number:=0;b_snM number:=0;b_ngay number:=b_ngay_hl;
begin
-- Dan - Tra so ID phi
if b_ngay in(0,30000101) then b_ngay:=PKH_NG_CSO(sysdate); end if;
select nvl(max(so_id),0) into b_so_id from bh_pkt_phi where so_nguoi=b_so_nguoi and b_ngay between ngay_bd and ngay_kt and loai='TN';
return b_so_id;
end;