INSERT INTO sigesp_cmp (codemp, procede, comprobante, fecha, codban, ctaban, descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin)
SELECT codemp, procede, comprobante, fecha, '007', '0906-0100000194', descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin
  FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008059'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008059'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008059'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008059'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

INSERT INTO sigesp_cmp (codemp, procede, comprobante, fecha, codban, ctaban, descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin)
SELECT codemp, procede, comprobante, fecha, '007', '0906-0100000194', descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin
  FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008058'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008058'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008058'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008058'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

INSERT INTO sigesp_cmp (codemp, procede, comprobante, fecha, codban, ctaban, descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin)
SELECT codemp, procede, comprobante, fecha, '007', '0906-0100000194', descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin
  FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008053'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008053'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008053'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008053'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

INSERT INTO sigesp_cmp (codemp, procede, comprobante, fecha, codban, ctaban, descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin)
SELECT codemp, procede, comprobante, fecha, '007', '0906-0100000194', descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin
  FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008116'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008116'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008116'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008116'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

INSERT INTO sigesp_cmp (codemp, procede, comprobante, fecha, codban, ctaban, descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin)
SELECT codemp, procede, comprobante, fecha, '007', '0906-0100000194', descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin
  FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008102'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008102'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008102'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008102'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

INSERT INTO sigesp_cmp (codemp, procede, comprobante, fecha, codban, ctaban, descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin)
SELECT codemp, procede, comprobante, fecha, '007', '0906-0100000194', descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin
  FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008065'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008065'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008065'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008065'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

INSERT INTO sigesp_cmp (codemp, procede, comprobante, fecha, codban, ctaban, descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin)
SELECT codemp, procede, comprobante, fecha, '007', '0906-0100000194', descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin
  FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008051'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008051'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000194'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008051'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '194-00000008051'
   AND fecha = '2009-03-10'
   AND codban = '---'
   AND ctaban = '-------------------------';

