you can use nextval('<sequence name>') to the next ID
nextval('<sequence name>')
insert into c_invoice (C_Invoice_ID, ....) select nextval('c_invoice_seq'), ... from ....