AAA

create or replace procedure PBH_MA_TPA_NGSK_LISTt(b_nv varchar2,b_nhom varchar2,b_lay_all varchar2)
AS
    b_ngay number:=PKH_NG_CSO(sysdate);
begin
  -- viet anh
insert into temp_1(c1,c2,c3)
  select '1',ma,ten from bh_ma_gdinh where FBH_MA_GDINH_NV(ma,b_nv)='C' and FBH_MA_GDINH_HAN(ma)='C';
end;