--operacion FCO2095 Tablas Planilla Integrada para Pensionados
delete from rel_oper_menus where ejecuta_operacion = 'FCO2096';
delete from rel_oper_modulos where operacion = 'FCO2096';
delete from operaciones where operacion = 'FCO2096';
delete from aut_operaciones where operacion = 'FCO2096';

insert into operaciones  values ('FCO2096', 'Control Planilla Integrada Pensionados', 2, 1, NULL,NULL,NULL,NULL);
insert into rel_oper_menus select 'F1', 20, NVL(max(secuencia),0) + 1, 2,
null, 'FCO2096' from rel_oper_menus where modulo='F1' and menu = 20;
insert into rel_oper_modulos values ('FCO2096','F1');
insert into aut_operaciones values ('ADAM','FCO2096',4);
COMMIT;

--operacion FCO3080 Cierre de período de autoliquidación Pensionados
delete from rel_oper_menus where ejecuta_operacion = 'FCO3080';
delete from rel_oper_modulos where operacion = 'FCO3080';
delete from operaciones where operacion = 'FCO3080';
delete from aut_operaciones where operacion = 'FCO3080';

insert into operaciones  values ('FCO3080', 'Cierre de período de autoliquidación Pensionados', 4, 1, NULL,NULL,NULL,NULL);
insert into rel_oper_menus select 'F1', 30, NVL(max(secuencia),0) + 1, 2,
null, 'FCO3080' from rel_oper_menus where modulo='F1' and menu = 30;
insert into rel_oper_modulos values ('FCO3080','F1');
insert into aut_operaciones values ('ADAM','FCO3080',4);
COMMIT;

--operacion FCO3090 Reapertura de período de autoliquidación Pensionados
delete from rel_oper_menus where ejecuta_operacion = 'FCO3090';
delete from rel_oper_modulos where operacion = 'FCO3090';
delete from operaciones where operacion = 'FCO3090';
delete from aut_operaciones where operacion = 'FCO3090';

insert into operaciones  values ('FCO3090', 'Reapertura de período de autoliquidación Pensionados', 4, 1, NULL,NULL,NULL,NULL);
insert into rel_oper_menus select 'F1', 30, NVL(max(secuencia),0) + 1, 2,
null, 'FCO3090' from rel_oper_menus where modulo='F1' and menu = 30;
insert into rel_oper_modulos values ('FCO3090','F1');
insert into aut_operaciones values ('ADAM','FCO3090',4);
COMMIT;

--operacion FCO5016 Archivo Planilla Integrada Pensionados
delete from rel_oper_menus where ejecuta_operacion = 'FCO5016';
delete from rel_oper_modulos where operacion = 'FCO5016';
delete from operaciones where operacion = 'FCO5016';
delete from aut_operaciones where operacion = 'FCO5016';

insert into operaciones  values ('FCO5016', 'Generar Archivo Planilla Integrada Pensionados', 7, 1, NULL,NULL,NULL,NULL);
insert into rel_oper_menus select 'F1', 50, NVL(max(secuencia),0) + 1, 2,
null, 'FCO5016' from rel_oper_menus where modulo='F1' and menu = 50;
insert into rel_oper_modulos values ('FCO5016','F1');
insert into aut_operaciones values ('ADAM','FCO5016',4);
COMMIT;

