delete from rptcertification 
where 
faasid in (select objid from faas where tdno between '2020-06-0011-01074' and '2020-06-0011-01188');
-- ------------------------------------------
delete from faas_signatory 
where 
objid in (select objid from faas where tdno between '2020-06-0011-01074' and '2020-06-0011-01188');
-- ------------------------------------------
delete from faas_previous
where 
faasid in (select objid from faas where tdno between '2020-06-0011-01074' and '2020-06-0011-01188');
-- ------------------------------------------
delete from rptledgerfaas
where 
objid in (select objid from rptledger where faasid in 
		(select objid from faas where tdno between '2020-06-0011-01074' and '2020-06-0011-01188'));
-- ------------------------------------------
delete from rptledger
where 
faasid in (select objid from faas where tdno between '2020-06-0011-01074' and '2020-06-0011-01188');
-- ------------------------------------------
delete from faasannotation_faas 
where 
faas_objid in (select objid from faas where tdno between '2020-06-0011-01074' and '2020-06-0011-01188');
-- ------------------------------------------
delete from faasannotation 
where 
faasid in (select objid from faas where tdno between '2020-06-0011-01074' and '2020-06-0011-01188');
-- ------------------------------------------

UPDATE faas SET state = 'INTERIM' WHERE tdno between '2020-06-0011-01074' and '2020-06-0011-01188';
				
UPDATE faas_list SET state = 'INTERIM' WHERE objid in (SELECT objid FROM faas 
				WHERE tdno between '2020-06-0011-01074' and '2020-06-0011-01188');
				
UPDATE rpu SET state = 'INTERIM' WHERE objid in (SELECT rpuid FROM faas 
				WHERE tdno between '2020-06-0011-01074' and '2020-06-0011-01188');

UPDATE realproperty SET state = 'INTERIM' WHERE objid in (SELECT realpropertyid FROM faas 
				WHERE tdno between '2020-06-0011-01074' and '2020-06-0011-01188');

UPDATE faas set datacapture ='1' WHERE tdno between '2020-06-0011-01074' and '2020-06-0011-01188';

UPDATE faas_list set datacapture ='1' WHERE tdno between '2020-06-0011-01074' and '2020-06-0011-01188';

---------------------------------------------------

UPDATE faas SET state = 'CURRENT' WHERE tdno between '2020-03-0007-00511' and '2020-03-0007-00511';
				
UPDATE faas_list SET state = 'CURRENT' WHERE objid in (SELECT objid FROM faas 
				WHERE tdno between '2020-03-0007-00511' and '2020-03-0007-00511');
				
UPDATE rpu SET state = 'CURRENT' WHERE objid in (SELECT rpuid FROM faas 
				WHERE tdno between '2020-03-0007-00511' and '2020-03-0007-00511');

UPDATE realproperty SET state = 'CURRENT' WHERE objid in (SELECT realpropertyid FROM faas 
				WHERE tdno between '2020-03-0007-00511' and '2020-03-0007-00511');

UPDATE faas set datacapture ='1' WHERE tdno between '2020-03-0007-00511' and '2020-03-0007-00511';

UPDATE faas_list set datacapture ='1' WHERE tdno between '2020-03-0007-00511' and '2020-03-0007-00511';