execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,12);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,11);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,10);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,08);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,07);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,06);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,05);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,04);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,03);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,02);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2017,01);
commit work;
execute procedure SPU_CUSTOTEMPOMEDIO_MODELOS(2018,01);
commit work;


select * from spu_despesa(2018,01);
commit work;
select * from spu_despesa(2017,12);
commit work;
select * from spu_despesa(2017,11);
commit work;
select * from spu_despesa(2017,10);
commit work;
select * from spu_despesa(2017,09);
commit work;
select * from spu_despesa(2017,08);
commit work;
select * from spu_despesa(2017,07);
commit work;
select * from spu_despesa(2017,06);
commit work;
select * from spu_despesa(2017,05);
commit work;
select * from spu_despesa(2017,04);
commit work;
select * from spu_despesa(2017,03);
commit work;
select * from spu_despesa(2017,02);
commit work;
select * from spu_despesa(2017,01);
commit work;

select * from SPU_RATEAMENTO3(2017,11,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,10,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,09,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,08,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,07,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,06,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,05,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,04,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,03,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,02,1,1);
commit work;
select * from SPU_RATEAMENTO3(2017,01,1,1);
commit work;


execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.11.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.10.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.09.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.08.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.07.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.06.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.05.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.04.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.03.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.02.2017'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.01.2017'),3) ;
commit work;


execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.01.2018'),3) ;
commit work;
execute procedure spu_tempomedio_modelos3(1,fn_end_of_month('01.12.2017'),3) ;
commit work;