Oracle 存储过程的 insert into select 问题

存储过程中我加入了这一个查询插入语句

  INSERT INTO BRANCHPLAN (hh,subbh,sl,kcsl,splitsl,plansl)
     SELECT a.hh,a.subbh,a.sl AS sl, nvl(t.kcsl,0) kcsl ,nvl(e.splitsl,0) splitsl,
     (a.sl-nvl(t.kcsl,0)-nvl(e.splitsl,0)) plansl
   
  FROM YW_KCK B
  inner JOIN YW_KCK B ON A.hh=B.HH 
    inner join  (SELECT sum(sl)AS sl,HH,subbh FROM SUBFHD WHERE KDRQ BETWEEN sysdate-7 AND sysdate AND subbh=v_subbh GROUP BY HH,subbh) A ON A.hh=B.HH 
    inner  JOIN  (SELECT   a.hh,sum(sl) kcsl   FROM   SUBPHK a WHERE a.subbh=v_subbh  GROUP  BY a.hh ) t   ON  a.hh=t.hh 
  LEFT JOIN (SELECT HH,sum(splitsl)  splitsl FROM DEALGOODSPLAN WHERE billdate>sysdate-2 and customguid=v_subbh and nvl(execok,0)=0
   AND nvl(isclose,0)=0 GROUP BY HH) E ON A.hh=E.HH
    WHERE A.subbh=v_subbh 
  AND nvl(B.FONLYMONEY,0)=0 AND nvl(B.HS_TAG,0)=0 AND nvl(B.FDELETED,1)=0   
    AND E.HH IS NULL    AND b.ZYBZ=0 and (a.sl-nvl(t.kcsl,0)-nvl(e.splitsl,0)>0);

报错inset有问题 join 部分也有问题但是直接执行sql没问题

有没有报错信息，把查询部分用括号，括起来试试。