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-0100000208', 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 = '208-00000011798'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011798'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011798'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011798'
   AND fecha = '2009-03-03'
   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-0100000208', 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 = '208-00000011885'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011885'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011885'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011885'
   AND fecha = '2009-03-11'
   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-0100000208', 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 = '208-00000011884'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011884'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011884'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011884'
   AND fecha = '2009-03-11'
   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-0100000208', 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 = '208-00000011890'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011890'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011890'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011890'
   AND fecha = '2009-03-11'
   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-0100000208', 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 = '208-00000011788'
   AND fecha = '2009-03-02'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011788'
   AND fecha = '2009-03-02'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011788'
   AND fecha = '2009-03-02'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011788'
   AND fecha = '2009-03-02'
   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-0100000208', 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 = '208-00000011791'
   AND fecha = '2009-03-02'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011791'
   AND fecha = '2009-03-02'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011791'
   AND fecha = '2009-03-02'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011791'
   AND fecha = '2009-03-02'
   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-0100000208', 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 = '208-00000011758'
   AND fecha = '2009-03-02'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011758'
   AND fecha = '2009-03-02'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011758'
   AND fecha = '2009-03-02'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011758'
   AND fecha = '2009-03-02'
   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-0100000208', 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 = '208-00000011869'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011869'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011869'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011869'
   AND fecha = '2009-03-11'
   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-0100000208', 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 = '208-00000011871'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011871'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011871'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011871'
   AND fecha = '2009-03-11'
   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-0100000208', 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 = '208-00000011868'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011868'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011868'
   AND fecha = '2009-03-11'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011868'
   AND fecha = '2009-03-11'
   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-0100000208', 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 = '208-00000011734'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011734'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011734'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011734'
   AND fecha = '2009-02-27'
   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-0100000208', 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 = '208-00000011690'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011690'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011690'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011690'
   AND fecha = '2009-02-27'
   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-0100000208', 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 = '208-00000011845'
   AND fecha = '2009-03-05'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011845'
   AND fecha = '2009-03-05'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011845'
   AND fecha = '2009-03-05'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011845'
   AND fecha = '2009-03-05'
   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-0100000208', 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 = '208-00000011837'
   AND fecha = '2009-03-05'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011837'
   AND fecha = '2009-03-05'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011837'
   AND fecha = '2009-03-05'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011837'
   AND fecha = '2009-03-05'
   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-0100000208', 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 = '208-00000011800'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011800'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011800'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011800'
   AND fecha = '2009-03-03'
   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-0100000208', 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 = '208-00000011799'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011799'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011799'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011799'
   AND fecha = '2009-03-03'
   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-0100000208', 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 = '208-00000011796'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011796'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011796'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011796'
   AND fecha = '2009-03-03'
   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-0100000208', 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 = '208-00000011797'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011797'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011797'
   AND fecha = '2009-03-03'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011797'
   AND fecha = '2009-03-03'
   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-0100000208', 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 = '208-00000011711'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011711'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011711'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011711'
   AND fecha = '2009-02-27'
   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-0100000208', 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 = '208-00000011665'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011665'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011665'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011665'
   AND fecha = '2009-02-27'
   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-0100000208', 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 = '208-00000011654'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011654'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011654'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011654'
   AND fecha = '2009-02-27'
   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-0100000208', 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 = '208-00000011656'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011656'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011656'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011656'
   AND fecha = '2009-02-27'
   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-0100000208', 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 = '208-00000011657'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011657'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011657'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011657'
   AND fecha = '2009-02-27'
   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-0100000208', 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 = '208-00000011661'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011661'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011661'
   AND fecha = '2009-02-27'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011661'
   AND fecha = '2009-02-27'
   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-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 = '-------------------------';