Different results with an insert...

I have a select statement which gives me the results I desire, which is anything less that 8%. If I use it in an insert which should bring anything over that is less than 8%, I get all the results as if the 8% criteria wasn't there. Any suggestions?

INSERT INTO PI_RPT
select a.t$cuno,
c.t$nama,
to_char(a.t$orno),
a.t$item,
e.t$dsca,
to_char(b.t$odat,'MM/DD/YY'),
to_char(b.t$netc, '99999.99'),
to_char(a.t$netc, '99999.99'),
to_char(a.t$netc - b.t$netc,'9999.99'),
to_char(round(((a.t$netc / b.t$netc) - 1),4) * 100, '999.99')
from 1 a, 2 b, 3 c, 4 e
where a.t$cuno = b.t$cuno
and a.t$cuno = c.t$cuno
and c.t$cfcg = ' 23'
and a.t$item = b.t$item
and a.t$item = e.t$item
and (round(((a.t$netc / b.t$netc) - 1),4) * 100) < 8
and b.t$netc <> 0
and a.t$odat >= '01-MAR-03'
and a.t$invd = trunc(sysdate - 1)
and a.t$fono <> 0
and e.t$ctyp not in (select t$ctyf
from 5)
and e.t$kitm <> 4
and (e.t$dscd = '400104'
or e.t$dscb in ('PAPER','TROPHY'))
order by 2,1,4,3