CREATE OR REPLACE FUNCTION "administrativo"."popular_solicitacao_empenho_item_despesa"() RETURNS void AS
$BODY$
    DECLARE
        sei_record    RECORD;  
    BEGIN
        FOR sei_record IN select id, id_despesa
    from administrativo.solicitacao_empenho_item sei 
    where sei.id_despesa IS NOT NULL
        LOOP
    INSERT INTO administrativo.solicitacao_empenho_item_despesa
        (id, id_solicitacao_empenho_item, id_despesa)
     VALUES ( (SELECT NEXTVAL('administrativo.seq_solicitacao_empenho_item_despesa')),
      sei_record.id, sei_record.id_despesa);
        END LOOP;
    END
$BODY$
LANGUAGE 'plpgsql' VOLATILE;