----------DELETES TRANSACCION 21 5007----------------------------------
DELETE FROM TSUBSISTEMATRANSACCIONESID WHERE CSUBSISTEMA='21' AND CTRANSACCION='5007';
DELETE FROM TSUBSISTEMATRANSACCIONES WHERE CSUBSISTEMA='21' AND CTRANSACCION='5007';
DELETE FROM TCOMPANIATRANSACCIONES WHERE CSUBSISTEMA='21' AND CTRANSACCION='5007';

----------DELETES REPORTE 21_REPORTEHORAS_EXTRAS------------------------
DELETE FROM TFORMATOREPORTEID WHERE CFORMATOREPORTE='21_REPORTEHORAS_EXTRAS';
DELETE FROM TFORMATOREPORTE WHERE CFORMATOREPORTE='21_REPORTEHORAS_EXTRAS';


----------INSERTS TRANSACCION 21 5007----------------------------------
insert into TSUBSISTEMATRANSACCIONESID (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, ORDENMENU, PRESENTARENMENU, INTERNA, FORMULARIOBASE, AFECTAINMOVILIZACION, CGRUPOTRANSACCION, PRESENTARENREVERSO, CNIVELMENU, LISTAVALOR, USACACHE, SUMACOMPONENTES, PROVISION, COMPLETARRUBROS, LOTEGENERICO, VERIFICANIVELSEGURIDAD, CUSUARIO_INGRESO, FINGRESO, ACUMULACONTADOR, PAGINA, ORIGENDESTINO, CONTROLAEFECTIVO, REQUIEREAUTORIZACION, EJECUTAENAUTORIZACION) values ('21', '5007', '01', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
insert into TSUBSISTEMATRANSACCIONES (CIDIOMA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, FHASTA, FDESDE, DESCRIPCION, SIGLAS, VERSIONCONTROL) values ('ES', '21', '5007', '01', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2013-05-31 11:18:09', 'REPORTE DE HORAS EXTRAS ', null, 0);
insert into TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, VERSIONCONTROL) values (2, '21', '5007', '01', 0);

----------INSERTS REPORTE 21_REPORTEHORAS_EXTRAS------------------------
insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, '21_REPORTEHORAS_EXTRAS', 'Loaded from Client');
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, '21_REPORTEHORAS_EXTRAS', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2013-05-31 11:17:41', '21_REPORTEHORAS_EXTRAS', 0);