INSERT INTO CLONINSUDB.TMP_CALC_REIN_GEN
   (SKEY, NYEAR, NMONTH, NBRANCH, NPRODUCT,
   NPOLICY, NCERTIF, NMODULEC, NCOVER, NBRANCH_REI,
   NBRANCH_LED, NTYPE, NCOMPANY, DEFFECDATE_PRE, NCAPITAL_COV,
   NCAPITAL_REI, NCURRENCY, NNUMBER, NNULLCODE, NSHARE_REI,
   NSHARE_CON, NTYPEMOVE, NPREMIUM, NRECAMOUNT, NDESCAMOUNT,
   NPREMIUM_REA, DSTARTDATE_CER, DEXPIRDAT_CER, DNULLDATE_CER, SBRANCH,
   SPRODUCT, SMODULEC, SCOVER, SBRANCH_REI, SBRANCH_LED,
   STYPE, STYPEMOVE, SCOMPANY, SCURRENCY, SNULLCODE,
   NUSERCODE, DCOMPDATE, NERROR, NPREMTOT, NRATE_COMMIS,
   NCOMMISSION, SSUBBRANCH)
 VALUES
   ('B2017030116470404401', 2017, 2, 10, 21,
    771196, 1, 525, 405, 118,
    26, 1, 2, TO_DATE('07/01/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0,
    0, 4, 0, NULL, 100,
    100, 7, -4010.510979, 0, 0,
    -4010.510979, TO_DATE('07/01/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/01/2019 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'Seguros Generales             ',
    'Incendio y Adicionales - Otros', 'EXTENSIÓN DE GARANTÍA RIPLEY', 'Extensión de Garantía', 'RetencionMas                  ', 'Seguro Extensión y Garantia',
    'Retención', 'Anula Cargo', 'CIA DE SEGUROS GENERALES CONSORCIO NACIONAL DE SEG          ', 'Uf                            ', 'Anu aPed.Cli                  ',
    60000, SYSDATE, 0, -4010.510979, 0,
    0, '3.C  ');