DELETE
FROM OBTL_TAX_PARAMETER TP USING OBTL_TAX_REPORT_PARAMETER TRP,
	OBTL_TAX_REPORT_GROUP TRG,
	OBTL_TAX_REPORT TR
WHERE TP.OBTL_TAX_REPORT_PARAMETER_ID = TRP.OBTL_TAX_REPORT_PARAMETER_ID
	AND TRG.OBTL_TAX_REPORT_GROUP_ID = TRP.OBTL_TAX_REPORT_GROUP_ID
	AND TR.OBTL_TAX_REPORT_ID = TRG.OBTL_TAX_REPORT_ID
	AND TR.VALUE ILIKE '%390%';


update AD_REF_DATA_LOADED set generic_id = CASE generic_id WHEN '6F24FCF4C7DE4ECBA507D795879649C2' THEN 'BB6EE1DADF5348B08A17339E45480FB3'
WHEN '57A7DE382D38444FA2F584402132F1CA' THEN '0E4BDBCC87E24BF08E3D3B1544055F84'
WHEN 'B1B0557411FD4FD78ADE86B9203C27A4' THEN '00ACC6AC67DB4DCE92CEE627D3215FD9'
WHEN '2BCAE33349474C2D9837CA72106A0972' THEN '07C2D1BC8A05424D9E6880C393EE9A9F'
WHEN '1EDA895A53024F2C896A6940C3F57135' THEN '1D4E5F314E9F4D06946C022C94A77AD4'
WHEN 'B4CD4EB0C0A04D8B98A84CF4B43B5E5C' THEN '268D665D879F46E9A181D5A349FD702F'
WHEN '95AD29126C31476DBB90D692028051EB' THEN '39FFF34D14A849C68E52FC7B33220805'
WHEN '3AAA10A75E9B4DACA3D65DA0D6553618' THEN '5662459E4E0341EFADB29F8C96F95149'
WHEN '1AAF27F24C74492396CFBD05B9E3125B' THEN '5A9C226236EF44FDB6338AB2A3359768'
WHEN '67C8B6A0AA3F4F94AD1E3BC837507A0C' THEN '5AC2512E8AA34CF5BB8BCA2B275C98E4'
WHEN 'F872AE78A5644A2FAE1235A5990EFBE8' THEN '655E71D04F794C46A2EFB74E51C281EA'
WHEN '482D9900D17D4AA99746833EE0DFF407' THEN '84A6A01F5C2A4ABFB1A36F2FA6EBD253'
WHEN 'ACC2A9E12B0E41DFAD65A11175A21FD0' THEN '1FEEB634039945649712CAD5DCF8F29A'
WHEN '248F854AC2BF4FDB92AB4A2D2CD560BF' THEN '0BC876D8C82447A4BB69BAF22938BCA7'
WHEN '922957DB9B924CCA9EE1CE2F0E4C2785' THEN '18B529D8C90E44D5962FDBDC6EEA3430'
WHEN '790980C3D0584105A5DC05837F99E6EF' THEN '1BCC56DF499F426EA9A982870288DE98'
WHEN 'D611B3C55C7647EB97C4D73F37F8E47A' THEN '2326595B716D42A1A4DCEFCE42867117'
WHEN 'AC3F43063555438993D9BA2142DA18D3' THEN '2710FD0C3E8846418A135320376F936C'
WHEN 'CBF841B1B7894C1B8E1D8305DD878883' THEN '3679A52509BC4D06BC254715B98D4D76'
WHEN 'A77D0A661D4A47779313ADA4B9CBD340' THEN '39136A7D505645ADB89BE39A626F5D74'
WHEN '72750B869514455E9ECBE3F243DF956D' THEN '8B099BCF4E064E68A560103857876567'
WHEN 'B6E06E03F63B415E98F213DF747FBAF9' THEN '8FB68E5A312944FBB0BAC1085455F142'
WHEN '642652F3EA414E77841111009D0C38EC' THEN 'C3F9B3B35A0542458AAD8CB91AED8E8B'
WHEN '254BFF3627494D479A216FC185BAF90E' THEN 'EB98CEFDE3244C389F8A576B572D21F9'
WHEN 'F4F9DA8578B844AFAF86ADC2BA9804EB' THEN 'FF0C75FC6F154257ADAF760954349002'
WHEN '1B55071C85404BC19DD24BE80378C77F' THEN '2259238EB503482AABB7DBB9B3A2E280'
WHEN 'C0412A46572B4997829ACAC256370497' THEN '3C3EFFB397444BC2A06DE31070833570'
WHEN '3A50AE862E4E4F9995DE614CDF0B0335' THEN '4C9AD4FA75504ADD88FCCCDB5C9BDC3C'
WHEN '36EBFE30A48B409D96B3D41238CA8C07' THEN '6A5BB46407304D41B2685A1E0A609AFD'
WHEN 'C7668E1DE2DD4EEDAC9E06D2F28632C1' THEN '24BFFC4A284543A9BBE34E0962FD710E'
WHEN '220C1D5B47274122862E0024C35EB8D3' THEN '6FA5067167F547348F6F9FEBBE946481'
WHEN '96EF5BB9FE964702A59794A153B8821F' THEN 'B5654796424C4F3DB84E33D1955C9143'
WHEN 'C4343F865F3942BB935D99520C177F53' THEN '5CEC6417B0EE410096260DB3032CC32F'
WHEN 'E0FCF95C8ED7456B8184DE3322FF22F4' THEN '1D01A548D8944766B46AB083B3857156'
WHEN '76C3EB5A207C4441A18CB16F351EDF87' THEN '262249F776C943D3B0E760085A6BC634'
WHEN 'EEDF54AC794448F2BE42784744891AB5' THEN '43D4F452830F411D80AC6AABA21945E4'
WHEN '391714D57EDF4A7685D779F8BF1224BC' THEN '45B5FDA6B6D84E8FB3E9DC3F93A301C5'
WHEN '6D0854E9E89B4DF0BF29B8C41BC150D8' THEN '5E1B31F428C244DFBA45701073182372'
WHEN 'A0C43B0D6E12438EB7B74CE87679F331' THEN '7DC74B9F7693402F910860F48953581F'
WHEN '8E5F65A15569451483D3325FDD933033' THEN '85F286915AAF492F8212DBAC37D95384'
WHEN '3964B8AB77B541E6B6A5C36DF85DB387' THEN '89FA3FF2803C4A4BB3D22CF4021054B0'
WHEN '964FFA8D05904ABD92130E0A428E2D7C' THEN 'A761382BE7C746679887A309019128B3'
WHEN '38C87BF9E1734F95B682ABDC85D79AD5' THEN 'C3F949977A604F6DBAB9AC9DE8D59718'
WHEN 'A371F1C2AA6F44C481E6F1BEDAABE5D7' THEN 'C4F551BD5E684846A4EF4318BBB15587'
WHEN '96913D0C40934346A4AF1E267FECF010' THEN 'EEC2399B752C494E8F8BAA3F52C1E54C'
WHEN 'C129D953D04B4E15B24C4DC6187A9FAE' THEN '6344ECDB15F04958AF894772ACD9C3A6'
WHEN 'B295356FB4F94DBFA17E1EBC3FAFED3B' THEN '224FE9D947394525BA4BCF4F518DD558'
WHEN 'D494215D9D7642349CF47361E24B6F44' THEN '69D6AD69A6B04D4892919805191A3285'
WHEN '411F86D250C34BCFBB5FD0443717B14C' THEN 'C45657B8B0EF4347B249ED9575080BC1'
WHEN 'D783DB8C5D9E4CB8B6492BF221EDC2FF' THEN '90F6621224374A709CB22C67C0636A6C'
WHEN '16B249A94FCD4C4E86EFB9E73D9E224C' THEN '24F1D7E989CA4942AD349ED510C9B45B'
WHEN '1EF115580824456E8A9D21EC7E228DD8' THEN '38E452EDC1F543AAACC02262B2D48626'
WHEN '3D286879BD8E4A82AFD3DBD93C500EB1' THEN '4FF2131341AE46EBB13D296ACD9EE1EE'
WHEN 'D473AEC0C0C1455AB32C1349E26F9CBC' THEN '53778AB7833442F58AFB297DD3614AA1'
WHEN 'EADDD2530163427D8F10F5A4A0901E93' THEN '61E80A06428A4448AA538BF96AD515B2'
WHEN '71DC82BAE7AC464696639F078BEF675F' THEN 'A2452656D56F49CFB447FC70B28B3A5D'
WHEN 'A8572931FCA048D392245E6F01600ADD' THEN 'A1FEEBAFB9D64C98B394D6FDCC00310D'
WHEN 'B9A42A5C874645C0976271365050D724' THEN '11B752DADB574A0ABE2C378C3DD11CFE'
WHEN '68F6C9ABC6F5413A9F9BFFD1C05E076C' THEN '1714AA7C268B4FCEA7190EB95078E319'
WHEN 'ACB3EDB2630342F5911A57CD9DD1D017' THEN '1DF7216F9CFC4AD79CF67BDADC39704C'
WHEN 'DD1D9D6850E74019940E371E8E9F8DFE' THEN '26606139B66C43529AAB84650D87F131'
WHEN '2E2E2163D47B43C7B045E594DB954CF2' THEN '2FC5A6B42B474E0D895953BC9606E210'
WHEN 'E2FF34A713EC43758EC2BB6666122DB7' THEN '751E1312A1D048B5ACC1A3E741E3A607'
WHEN '5CF828D387364A18B6C365FF7B8BF98A' THEN '775F192250994124A050003AAAF03BB2'
WHEN 'B489AFEF2217431593D6093B5D1185E9' THEN '873E96EF047042C38D6EF1B8A84FE56B'
WHEN '28C20F49877E4018A41BEA5E22F35E65' THEN 'A1CB14E52B3C4982BAF3C79F111AB6EF'
WHEN '4F2360471ED9412BB73B01AC01A6B441' THEN 'B06BCC8FE1544783B8B882ACDB5E8AB7'
WHEN '02E9A97D6BB44BDE8396B2779345A365' THEN 'B521632DB1B941FB903A142B0651CF41'
WHEN '4EA36DB400A440F9B39273DD7A52B034' THEN 'C89DC512F94D4C78B3ECC9C951AAD652'
WHEN 'E4811FA88E59445B957F5F0CDCB8C686' THEN 'CC03A5D902BB4776B067EB73F17558EF'
WHEN 'DEF4EB369ED549B897EEBB282442DEDB' THEN 'D5C979309B624575BAA3FDC521C0E9B1'
WHEN '82E131B3734D4D67832E18C98466458B' THEN 'DF17D6CAC3494E34BC9CE934D66BA1DB'
WHEN '9CC491EB5C754BA2AC3C7C1B1AD35325' THEN 'E9D5F3F618C741B1A30A1BEA3F7A89D7'
WHEN 'C1A6074ACD46483CB3199F58F338134C' THEN 'AF3A92A05CFD41C885903C0CC272BD42'
WHEN '173E0920CA8541C3A16B665B06402761' THEN 'E7C74DC4BA124EAC85BCBB15DCB90786'
WHEN '609C01772533483080730974D67C011D' THEN 'C700F8F4B5B842B087DB0DC0E7EA2CD9'
WHEN '49B40203CAF244BF8C712FB9C60FFDD4' THEN 'A294B73EF1BC4721BEB43F05E231221D'
WHEN 'A0E8284954FC45ADA639C89009D79591' THEN 'C9732DE9106C4C2FABDBA93F113322D4'
WHEN '7ED6BD40F43C4C68AA629F91244D8769' THEN '05982093F1754760B454ECC213704A9D'
WHEN '2B5F7EF0729A49AD82B59DF670FA5986' THEN '0BEBD99A86894FA19E2ED826CD8E460E'
WHEN '2D111AD2909B498EA5BD2969E548672F' THEN '13F7A61F092347E7956C64A3F06EF04A'
WHEN '3BA4BF4E252A4600AE8B6B90775A60AE' THEN '3C36197B9621470AB97EC2DD57F6590D'
WHEN '167EC3172C1B408687409DCCC2B6C74D' THEN '40F23289E30B4993B46CD75273995DCB'
WHEN '7BA7587A090B4EB7AC40A42D7FB60312' THEN '6D3D21E2071D4BFBB2E0266B689A2C0C'
WHEN 'C2A182F98F24442F9A709B13E6CDD967' THEN '746D55A3452A48AFA300A21CBD844D7D'
WHEN '55291CA88D2C49588FE325FD0CF4DBB0' THEN '90BDAEFCB89A4F89A9104B46D65DE94E'
WHEN '4098F1A48D9247FEB2E3BBCFBE7A046D' THEN 'AD0F97F15B894CAFBD47F06F82A78618'
WHEN '62DFCA3B4C0749F4A43B437C15C18C83' THEN 'E2E278925F124EC3AEBDFC6658ED174D'
WHEN 'A69EFE1D79104F118C848F49CABAD058' THEN 'CA4CB8E891BF4096825E429E7F770693'
WHEN '269588BF394D420F814A2D725A7947D5' THEN '2DBF8E9B2F214AA0B984ED83ED41D550'
WHEN 'A92F18EE54224DC08202A176D123653A' THEN '3213207F755745678E16652BC422D8BC'
WHEN '857C501752DA429D8F905378D1014D00' THEN '5CC619F469D34659ADF93E5E455FDF0A'
WHEN '9D0B64C7E2A046C3A2F50D73865E542F' THEN '75C3F2A4104B4B6484322570312A52CE'
WHEN '07A8FBC60C074836A17381CA55D25ED7' THEN '80E0BC65D7A14B1098E1274536DB795F'
WHEN '5EBFF8E56F51428BB260B40A862BDAF7' THEN 'A598F8EF80E94AD59EA67ACE8CB06D9C'
WHEN 'BAD3897FD4CF4B8F8C30AFB21B741BC3' THEN 'FB515801ACA84B6D998EF88706671118'
WHEN '8552E60C7BB440788CA0EBF16F2B63F4' THEN 'F08B78CB704C49049C5CF1179A3C2335'
WHEN '5EC14F60D6E64685A131FC0553CFD8DC' THEN '3FFA2513B28943489BA8221DA2B85370'
WHEN '8469496D3895421D89B9F5A7C69F171B' THEN 'C29757B450F04DABB7AE130444356ED6'
WHEN 'D29910F1141346BEB070593740B8F474' THEN 'F6AA3181D1A4453482B001F63BE54CCC'
WHEN 'D330103867854299A8D2B94B7F956645' THEN '2FFD5A813E6244D196D16363F290FB8F'
WHEN 'D051B88F4E684751A9F2593BE15F7248' THEN 'F8881619DCE149BD9D70FBC2D2EAA43A'
WHEN 'B68782A7005B4AE88A58F6A6B24699F8' THEN '676A7EBBA4CE4B1FA7E4A48210E35979'
WHEN '1D6882AFC1D6412AAD516B4F1F9D7F8C' THEN 'E61B76CE3C724C7987F3B335F1B1272F'
WHEN 'A15A01DCAEF244BBAC08A6229FEAFFED' THEN 'FC2784F36DCF489A97CFE1650A01495B'
WHEN '7F2B0793C315476D8FD6DD26899C2009' THEN 'D6F1CF7BEA434A26A089AD0BBF758944'
WHEN 'A4808B1BDC6D4495BD40DC5E77046177' THEN '0B1165144F3644E8875A68F13E832B2D'
WHEN '7DEC9F62C37E4E48B0EA4EBAC3904673' THEN '0C59AB81B56246B7B58364852E4F7264'
WHEN '0C77CA8A5E1C456AB4C2AD9A143FBC1F' THEN '1C58AF429C3D48A5A6BBE9E6BE53D4FF'
WHEN '7F232F8595D34C878BFDE337533FE791' THEN '43DE749C1C9346B99843BCF9751AEEC5'
WHEN 'E4462516E7534882A9147FD2BA01E3C3' THEN '4827450E1D1D47508AF398AEACB3875E'
WHEN '4FE05D1017AA4EBE95B765C56D54C490' THEN '4F7DB1CA99814579AD4385DBC1EE2B5E'
WHEN '30016EDEC85D414A93B49AD6E2EEE763' THEN '5D3C206B78834CDBBADB2C0256F91801'
WHEN '440419C5F43E416BABD9298C6109F3F8' THEN '67398893AE5644AFA1EEA878C564CEF5'
WHEN 'FBEB73F555B34E29BA7BA0FC273A44B5' THEN '77FEF240BA2F40E4B6A231D38385B6ED'
WHEN 'B96E9E4A6D2E41A895456390ABDD2CBD' THEN 'AAE170CC4D5F467D9B0DA7224A2C46A7'
WHEN '092188E256444C05802F92814FBEF2E9' THEN 'B3F5C1745B3241C289133A753E981DEC'
WHEN '9317E3DD2680464385C0B192DDBFC137' THEN 'C2730FB335CB49AD9CB6A5D02934AE06'
WHEN '9640CFA1A4BC45F4AEEDA9FC0D28DC3F' THEN 'CA5F993A72DA429AA5401C7C6BED66ED'
WHEN '9593A22E32444A35927A2DE9C0A76CA4' THEN '30EB643608374B30846EEF679646EEBF'
WHEN '75061D38AA68441D8A4DF4BDB58AFF37' THEN '058EFBEA4C154C01BD06887FDD001C45'
WHEN 'DEE7FBD912D24038B70CD410CBC7753B' THEN '142DD4830A754DEB839B247D272D7545'
WHEN 'BB01EC428490459FA6CFAE311A84EA44' THEN '2507C5CB4011444395BDD2C7D75CD4E6'
WHEN '94DF2E445A274B0ABA128DB4961CD1E7' THEN 'B0F8161F5D764B2F879D3DA387C74E0C'
WHEN '56BA8905F41345B89B6BA83E4309E7D1' THEN 'CA528A030D024021B77B7D893CE528BF'
WHEN 'C73B3BA0C14E46F59194E48BB4BB04AC' THEN 'FEFAD5589EE1410285DFF30F3BE7613D'
WHEN '8764550626914A4A819411226D8C5DE1' THEN 'FF1622F6702D42BDAC8C9197122BE65B'
WHEN '2D7FC967522B403AAE4AF1587D390CF8' THEN '3528865239B54D40894A6F7C2C4C5257'
WHEN '24EFE4FF8CA74ECB8654707D0F1D78DA' THEN 'C2E7260EF1EE41F88D974A2CA6D54B73'
WHEN 'E1CBA8E30E274D21AE59DB10A440235F' THEN '3C0868F91C5146DBA14E094003CED624'
WHEN '00B9F739DC104A9B8A3EE2636DAF0499' THEN '11961AAECA4144A48C4E06026C017110'
WHEN 'CE9DF7CBC43A4CDEAC00CD010DCD4595' THEN '154E4465203B4072BD617680DA5E0DDC'
WHEN 'B5183A9F0D0146BE9F528BEE6E702BB9' THEN '2808EE768FAD4147933CD270C0DEBE9B'
WHEN 'BFEE06AF0E3B47A2B198DA2A715E9168' THEN '384DB6F2CD61475F85CAF2646D4210B6'
WHEN '2F8B374B0C794293960B0FB1E1D8500B' THEN '6E47669C21454147AC45EED501A5C7F0'
WHEN '450FB70437CC45DF87F466F92C2AC4ED' THEN '712A238519C741519E295232AEB903F9'
WHEN '4DF9E3599B194E809D59F5D60C9C4D28' THEN '800EBA899CC649FE82FDAFE52E79C37C'
WHEN 'FC9105E84F744610A1D5FD5387C30BDA' THEN 'A37DA67217C84328B867F641B08FFC5D'
WHEN '79452A99C3214555ACF221601B3CF2B8' THEN 'A65204782A8647C883EA949A7B2DA204'
WHEN '8FC02D9CB27242E6BF61CA5AF26328EA' THEN 'A8D980BE4FE34CF9926FD288D9808606'
WHEN '2AA38EA8303042A388864080E57DF7D2' THEN 'D11CAB63DDD448EE9DA08294D0A72C00'
WHEN '47CB33E4C1A849189FEC662C9AC8178C' THEN 'DECA1E8BD11F440C9601B6FCE0D0E737'
WHEN '158A580FDDED41089D50FE87574FDACD' THEN '402568DDB8F940E4B9D7EBD95D25A085'
WHEN '3EB6A164E45E4F478149DBCFEB09D926' THEN '2E9C5BA279DD415DBB8700722EAD4AC1'
WHEN '426347FE11FE4F369D439605ABF5EFBD' THEN '9AA7C80827914FCABEE03C60D41ECEBB'
WHEN '82F3CF7172344BE6B3614A887F7A1154' THEN 'EE4E8937F6F74EDD8383F0693DE1D119'
WHEN '9C25678742AA4A8AB2D88CE06D628636' THEN '4A11203B95314CC4A88D13AF5D64C611'
WHEN 'CD3EC481D535426FB9685D16808E25C3' THEN '9CC6F17EF3C6449A8936FBD8FBB1715D'
WHEN '64F2AC847A3E4EED9AB7D1F418CE2B28' THEN '5E2AF4E82BCA46EAA8829F8CF53C48A4'
WHEN '42FD7F51919347B596547C9A6192ACBF' THEN '0EB757F5BC114A9887B22B5306C029BE'
WHEN '9656B9F7714749309E24CB75BB61E0A1' THEN '467A1FECE48A44068F78F53B68E3FC1E'
WHEN '4D55E62F7AAE4FC48A2937DDE759B22C' THEN '51CA30F050DD4322ABA3B28514CAB26A'
WHEN 'BE506827233B44879495EB4DBD812B0A' THEN '6DE0D90B2C644A28ADFD000CB60A2AFB'
WHEN '601B57BF84424A43B9439E9F035489FA' THEN '6FFAD86E8FBD4AC8925335BB725706CA'
WHEN '5B7ACB4B82C24A989AE2EFF07B29595C' THEN '785DEC0AD5724970A11BC1CC5F1750C9'
WHEN '385CB41F89F04D4E8771FB91B191FD34' THEN '9069EF0A8A06473C8A50DBE08FC67B41'
WHEN '8A9B83EF9723401CB5518C160ED10BCE' THEN 'A4D146CD52AB4D6B8EF8D4AB6C63800A'
WHEN 'E2C0D6BD7EBD41ABB2F48E290A9BD133' THEN 'E7EF867888484E13B4BB1DD019249FE3'
WHEN 'FE6264B7DE7742F5B7E9DD25787E78E8' THEN 'ED6E20C00A73450FB0A18DB12EA5DE5E'
WHEN 'C4349320E11140ED919956CF809B0934' THEN '5F8350AFF9CD41E6B054C789EF0C4703'
WHEN '57ADD23640FE4DDC99E41CDAA0EEA939' THEN '24137C89316F4C4B9FB4D0BD979BF9D2'
WHEN 'F631781565924169AA3F9CCEB389D2EE' THEN 'BBAB31B05F0E44849B457FB36B37D8D2'
WHEN 'BA2E087D7E7E400A9FF7AB0C51909CBB' THEN 'ED7CE7CB9FCD45378C4FD9F239F7B072'
WHEN '0580CBA828204661A7E254A6CC6C21BB' THEN '8A7D17899EE94E4EA8E2A2D68135D1FC'
WHEN '4EDF2651ABD74526976BE7A39BC21380' THEN '048EFC2F1C4745B8ACF33E40841066B0'
WHEN '46CA6D7A32AF4BC386EFB37399251FAB' THEN '38A69F7719C4418EBBE1A3F779972E46'
WHEN 'A43071341A9F4EDBB57D777B8E5D8851' THEN '82BA2D01577F48319FA0E7E15EB3DD76'
WHEN '56ECCFA114364A23903BD0BC90338F21' THEN '951140A9A2744BB085E08B2CAC6A0FF4'
WHEN 'A1902B0B9F7546A8A6EBB97016B02B38' THEN 'A2284F61F8D74CF083057B4E651D3D36'
WHEN 'B25EE6F4486E47519FAF78C0451FBAB2' THEN 'FE635359502D42E3A92B1FC68A957FC5'
WHEN 'F6A7C16870AA43FD882C3FFC7DD6C764' THEN 'AEF5A87B776440E999EFCA6D4B2D5FC7'
WHEN '9B1EBB6A5DD84D4DB9C792455432D1E9' THEN 'CE1CBC09D90D4F27AB69C8F43BF46DE8'
WHEN '459A4949A41848F58B30C7CC113EA04C' THEN 'B04C8F765835438B86765BFD9751AFE7'
WHEN '8D8CDE2016534081A89E1C00F21D8000' THEN '0EA455F155F0458E96273B516715612B'
WHEN 'DE971BDBC1C9429AB9779A83D55291D1' THEN '1A7B25B8876844ABA26B8E17D9B0E1C7'
WHEN '67DFE06F9ACB4C06A185C7C89B3357C5' THEN '3E6D9839E218454D9DE699D0E13679F9'
WHEN '2F8CFA5A278541FBAF268E9E9D670BCF' THEN '538E46263E96460494FEBCF7DC71C56E'
WHEN 'B12E70DB67A54C96BB1851F79F3EB196' THEN '82B7B505B68440E49C6E3719623C0199'
WHEN '4312A5A457CA43628EB5B3283F5F4C43' THEN '85509E35C279426CB7DD5DF7B635F3F8'
WHEN '5304C7AFE9154BC0B9194C4EBD7D5917' THEN '8FAEC2A0EB074CD4BEF786AF636F6E5A'
WHEN 'D7C359AE852F4055BBD8C4320A10ED17' THEN '9B58774C729649298EE8DF7BEBC966EF'
WHEN '247B343747EF42A3A882922C1BDCCD8E' THEN 'AB35C735DF8D421CB345AB3E427A52B9'
WHEN '1043EA4D89384E14AF1747268D012496' THEN 'E8201220A6D94AB78BDF0D8D4DD63EA7'
WHEN '63D601BE56514F3C98791DD7534AF385' THEN 'C0CD1F29DE0149DE924A66D51F65B885'
WHEN '71F6D473971E4E5EA21C7EF8F1E3437F' THEN '0CD8D8444D7545DFA80ABBB5558AB50A'
WHEN '4E47A713C279405F993BB685A05EE16C' THEN 'C7AE6D5F041B47C38CCED44F965FB646'
WHEN '92091C9B3AE841569BB9645B148024CC' THEN '30C9B51AE30142CEA7BCA865F0E58796'
WHEN '1FB1C729935D459095721ED315733CD2' THEN 'D0639FE824264E3EBE07F39780B85872'
WHEN '4BE24369A4F244B889E6C6362CCFB197' THEN '19A11EFD61364A2BB100D07E2EA8B180'
WHEN '832E29CCEB124C78BA991D153E525E72' THEN 'BEC604188C994F75A59CD12808428F4D'
WHEN '4FECBBD0C3CA40E88437A9D14A497DC0' THEN 'DE0F7368D85E4776B5DAECE0D8EE81BF'
WHEN 'EE165193B9544E6AB5239674D07023C3' THEN '3CCC5D91D0554359BAE612B45792A54A'
WHEN '7F98769DFE5C45DABC3ED8BE42239073' THEN '6C4841CCF41644398DFBAF97CEB947A8'
WHEN 'D1C6CDBF071D47ACB821C7092E8D5FF5' THEN 'DE8A6628F29C44B78EE1BF9FDAEFD8EF'
WHEN '3BB0FD5DF8834078AE79602945438FB0' THEN '0D1C5DEB185241F0A6329CA9EE4728F1'
WHEN '9D2D66BC3E4445AB989600388EC95158' THEN '170C225FC8D34CB483763FF914F11029'
WHEN '97550D2E1E9F415EB2639228300E7132' THEN '1759250A87BC41EFAD1A63B9AF3DC60D'
WHEN '3E942E807B3E43478370CE71C62F72F2' THEN '22842398F8894BF2A36C062F65169759'
WHEN 'F9B7DE0C6EB54820A8324342CF7F12DA' THEN '2CFD4A54F1744AB08C5BB7A83CED98F7'
WHEN '15016F9D0E7E416DAFEC2E60DA28F0B6' THEN '63A117EEBDC347CD8D745C45DABFA96B'
WHEN 'DA1974494E2E4D629037F1B3E3C7B8D5' THEN '87CFB12351FA45B98C8C0695EE3A2D71'
WHEN '367A5FDAA0CB48668D9A4421999E6DE2' THEN '8CD804FAFE6F45319AAC70CB1BC93C88'
WHEN 'EFD05B0D61924ADF9901367D1BE13E09' THEN '94B50A78DC0646D8BC695C8BD8A7ABDB'
WHEN 'EC5511646E9E4D90B16965B9E08050E1' THEN '97E3A82DC8964295853C06917D04475B'
WHEN 'A9C816E0BB87486296B25C12EB790057' THEN '9B8FE33E909F4F428F8E553445D6C773'
WHEN '95EBFA45929A454E9E222F09B09B8DAB' THEN 'C2607AE5848A4F66BD7E0D3CDA10015D'
WHEN '72BE0F6E1ADC4FEDAAB8269287537FFC' THEN 'CB9B9A7731134A52AAD77EEFA37FF6B0'
WHEN '5FE159EB2CA043168D93E63701254CF7' THEN 'D2FE302F423A4868914BF66FDD9C6A76'
WHEN '0585673B87C64BF3A6299EF445F4F069' THEN 'D7025067C5C943A39CF74D8BAD9374D8'
WHEN '861764BAD1354F128F2B0D1C90B12F48' THEN 'FB689BEE268D48ECB10CFFD870639196'
end
WHERE generic_id IN (
'6F24FCF4C7DE4ECBA507D795879649C2',
'57A7DE382D38444FA2F584402132F1CA',
'B1B0557411FD4FD78ADE86B9203C27A4',
'2BCAE33349474C2D9837CA72106A0972',
'1EDA895A53024F2C896A6940C3F57135',
'B4CD4EB0C0A04D8B98A84CF4B43B5E5C',
'95AD29126C31476DBB90D692028051EB',
'3AAA10A75E9B4DACA3D65DA0D6553618',
'1AAF27F24C74492396CFBD05B9E3125B',
'67C8B6A0AA3F4F94AD1E3BC837507A0C',
'F872AE78A5644A2FAE1235A5990EFBE8',
'482D9900D17D4AA99746833EE0DFF407',
'ACC2A9E12B0E41DFAD65A11175A21FD0',
'248F854AC2BF4FDB92AB4A2D2CD560BF',
'922957DB9B924CCA9EE1CE2F0E4C2785',
'790980C3D0584105A5DC05837F99E6EF',
'D611B3C55C7647EB97C4D73F37F8E47A',
'AC3F43063555438993D9BA2142DA18D3',
'CBF841B1B7894C1B8E1D8305DD878883',
'A77D0A661D4A47779313ADA4B9CBD340',
'72750B869514455E9ECBE3F243DF956D',
'B6E06E03F63B415E98F213DF747FBAF9',
'642652F3EA414E77841111009D0C38EC',
'254BFF3627494D479A216FC185BAF90E',
'F4F9DA8578B844AFAF86ADC2BA9804EB',
'1B55071C85404BC19DD24BE80378C77F',
'C0412A46572B4997829ACAC256370497',
'3A50AE862E4E4F9995DE614CDF0B0335',
'36EBFE30A48B409D96B3D41238CA8C07',
'C7668E1DE2DD4EEDAC9E06D2F28632C1',
'220C1D5B47274122862E0024C35EB8D3',
'96EF5BB9FE964702A59794A153B8821F',
'C4343F865F3942BB935D99520C177F53',
'E0FCF95C8ED7456B8184DE3322FF22F4',
'76C3EB5A207C4441A18CB16F351EDF87',
'EEDF54AC794448F2BE42784744891AB5',
'391714D57EDF4A7685D779F8BF1224BC',
'6D0854E9E89B4DF0BF29B8C41BC150D8',
'A0C43B0D6E12438EB7B74CE87679F331',
'8E5F65A15569451483D3325FDD933033',
'3964B8AB77B541E6B6A5C36DF85DB387',
'964FFA8D05904ABD92130E0A428E2D7C',
'38C87BF9E1734F95B682ABDC85D79AD5',
'A371F1C2AA6F44C481E6F1BEDAABE5D7',
'96913D0C40934346A4AF1E267FECF010',
'C129D953D04B4E15B24C4DC6187A9FAE',
'B295356FB4F94DBFA17E1EBC3FAFED3B',
'D494215D9D7642349CF47361E24B6F44',
'411F86D250C34BCFBB5FD0443717B14C',
'D783DB8C5D9E4CB8B6492BF221EDC2FF',
'16B249A94FCD4C4E86EFB9E73D9E224C',
'1EF115580824456E8A9D21EC7E228DD8',
'3D286879BD8E4A82AFD3DBD93C500EB1',
'D473AEC0C0C1455AB32C1349E26F9CBC',
'EADDD2530163427D8F10F5A4A0901E93',
'71DC82BAE7AC464696639F078BEF675F',
'A8572931FCA048D392245E6F01600ADD',
'B9A42A5C874645C0976271365050D724',
'68F6C9ABC6F5413A9F9BFFD1C05E076C',
'ACB3EDB2630342F5911A57CD9DD1D017',
'DD1D9D6850E74019940E371E8E9F8DFE',
'2E2E2163D47B43C7B045E594DB954CF2',
'E2FF34A713EC43758EC2BB6666122DB7',
'5CF828D387364A18B6C365FF7B8BF98A',
'B489AFEF2217431593D6093B5D1185E9',
'28C20F49877E4018A41BEA5E22F35E65',
'4F2360471ED9412BB73B01AC01A6B441',
'02E9A97D6BB44BDE8396B2779345A365',
'4EA36DB400A440F9B39273DD7A52B034',
'E4811FA88E59445B957F5F0CDCB8C686',
'DEF4EB369ED549B897EEBB282442DEDB',
'82E131B3734D4D67832E18C98466458B',
'9CC491EB5C754BA2AC3C7C1B1AD35325',
'C1A6074ACD46483CB3199F58F338134C',
'173E0920CA8541C3A16B665B06402761',
'609C01772533483080730974D67C011D',
'49B40203CAF244BF8C712FB9C60FFDD4',
'A0E8284954FC45ADA639C89009D79591',
'7ED6BD40F43C4C68AA629F91244D8769',
'2B5F7EF0729A49AD82B59DF670FA5986',
'2D111AD2909B498EA5BD2969E548672F',
'3BA4BF4E252A4600AE8B6B90775A60AE',
'167EC3172C1B408687409DCCC2B6C74D',
'7BA7587A090B4EB7AC40A42D7FB60312',
'C2A182F98F24442F9A709B13E6CDD967',
'55291CA88D2C49588FE325FD0CF4DBB0',
'4098F1A48D9247FEB2E3BBCFBE7A046D',
'62DFCA3B4C0749F4A43B437C15C18C83',
'A69EFE1D79104F118C848F49CABAD058',
'269588BF394D420F814A2D725A7947D5',
'A92F18EE54224DC08202A176D123653A',
'857C501752DA429D8F905378D1014D00',
'9D0B64C7E2A046C3A2F50D73865E542F',
'07A8FBC60C074836A17381CA55D25ED7',
'5EBFF8E56F51428BB260B40A862BDAF7',
'BAD3897FD4CF4B8F8C30AFB21B741BC3',
'8552E60C7BB440788CA0EBF16F2B63F4',
'5EC14F60D6E64685A131FC0553CFD8DC',
'8469496D3895421D89B9F5A7C69F171B',
'D29910F1141346BEB070593740B8F474',
'D330103867854299A8D2B94B7F956645',
'D051B88F4E684751A9F2593BE15F7248',
'B68782A7005B4AE88A58F6A6B24699F8',
'1D6882AFC1D6412AAD516B4F1F9D7F8C',
'A15A01DCAEF244BBAC08A6229FEAFFED',
'7F2B0793C315476D8FD6DD26899C2009',
'A4808B1BDC6D4495BD40DC5E77046177',
'7DEC9F62C37E4E48B0EA4EBAC3904673',
'0C77CA8A5E1C456AB4C2AD9A143FBC1F',
'7F232F8595D34C878BFDE337533FE791',
'E4462516E7534882A9147FD2BA01E3C3',
'4FE05D1017AA4EBE95B765C56D54C490',
'30016EDEC85D414A93B49AD6E2EEE763',
'440419C5F43E416BABD9298C6109F3F8',
'FBEB73F555B34E29BA7BA0FC273A44B5',
'B96E9E4A6D2E41A895456390ABDD2CBD',
'092188E256444C05802F92814FBEF2E9',
'9317E3DD2680464385C0B192DDBFC137',
'9640CFA1A4BC45F4AEEDA9FC0D28DC3F',
'9593A22E32444A35927A2DE9C0A76CA4',
'75061D38AA68441D8A4DF4BDB58AFF37',
'DEE7FBD912D24038B70CD410CBC7753B',
'BB01EC428490459FA6CFAE311A84EA44',
'94DF2E445A274B0ABA128DB4961CD1E7',
'56BA8905F41345B89B6BA83E4309E7D1',
'C73B3BA0C14E46F59194E48BB4BB04AC',
'8764550626914A4A819411226D8C5DE1',
'2D7FC967522B403AAE4AF1587D390CF8',
'24EFE4FF8CA74ECB8654707D0F1D78DA',
'E1CBA8E30E274D21AE59DB10A440235F',
'00B9F739DC104A9B8A3EE2636DAF0499',
'CE9DF7CBC43A4CDEAC00CD010DCD4595',
'B5183A9F0D0146BE9F528BEE6E702BB9',
'BFEE06AF0E3B47A2B198DA2A715E9168',
'2F8B374B0C794293960B0FB1E1D8500B',
'450FB70437CC45DF87F466F92C2AC4ED',
'4DF9E3599B194E809D59F5D60C9C4D28',
'FC9105E84F744610A1D5FD5387C30BDA',
'79452A99C3214555ACF221601B3CF2B8',
'8FC02D9CB27242E6BF61CA5AF26328EA',
'2AA38EA8303042A388864080E57DF7D2',
'47CB33E4C1A849189FEC662C9AC8178C',
'158A580FDDED41089D50FE87574FDACD',
'3EB6A164E45E4F478149DBCFEB09D926',
'426347FE11FE4F369D439605ABF5EFBD',
'82F3CF7172344BE6B3614A887F7A1154',
'9C25678742AA4A8AB2D88CE06D628636',
'CD3EC481D535426FB9685D16808E25C3',
'64F2AC847A3E4EED9AB7D1F418CE2B28',
'42FD7F51919347B596547C9A6192ACBF',
'9656B9F7714749309E24CB75BB61E0A1',
'4D55E62F7AAE4FC48A2937DDE759B22C',
'BE506827233B44879495EB4DBD812B0A',
'601B57BF84424A43B9439E9F035489FA',
'5B7ACB4B82C24A989AE2EFF07B29595C',
'385CB41F89F04D4E8771FB91B191FD34',
'8A9B83EF9723401CB5518C160ED10BCE',
'E2C0D6BD7EBD41ABB2F48E290A9BD133',
'FE6264B7DE7742F5B7E9DD25787E78E8',
'C4349320E11140ED919956CF809B0934',
'57ADD23640FE4DDC99E41CDAA0EEA939',
'F631781565924169AA3F9CCEB389D2EE',
'BA2E087D7E7E400A9FF7AB0C51909CBB',
'0580CBA828204661A7E254A6CC6C21BB',
'4EDF2651ABD74526976BE7A39BC21380',
'46CA6D7A32AF4BC386EFB37399251FAB',
'A43071341A9F4EDBB57D777B8E5D8851',
'56ECCFA114364A23903BD0BC90338F21',
'A1902B0B9F7546A8A6EBB97016B02B38',
'B25EE6F4486E47519FAF78C0451FBAB2',
'F6A7C16870AA43FD882C3FFC7DD6C764',
'9B1EBB6A5DD84D4DB9C792455432D1E9',
'459A4949A41848F58B30C7CC113EA04C',
'8D8CDE2016534081A89E1C00F21D8000',
'DE971BDBC1C9429AB9779A83D55291D1',
'67DFE06F9ACB4C06A185C7C89B3357C5',
'2F8CFA5A278541FBAF268E9E9D670BCF',
'B12E70DB67A54C96BB1851F79F3EB196',
'4312A5A457CA43628EB5B3283F5F4C43',
'5304C7AFE9154BC0B9194C4EBD7D5917',
'D7C359AE852F4055BBD8C4320A10ED17',
'247B343747EF42A3A882922C1BDCCD8E',
'1043EA4D89384E14AF1747268D012496',
'63D601BE56514F3C98791DD7534AF385',
'71F6D473971E4E5EA21C7EF8F1E3437F',
'4E47A713C279405F993BB685A05EE16C',
'92091C9B3AE841569BB9645B148024CC',
'1FB1C729935D459095721ED315733CD2',
'4BE24369A4F244B889E6C6362CCFB197',
'832E29CCEB124C78BA991D153E525E72',
'4FECBBD0C3CA40E88437A9D14A497DC0',
'EE165193B9544E6AB5239674D07023C3',
'7F98769DFE5C45DABC3ED8BE42239073',
'D1C6CDBF071D47ACB821C7092E8D5FF5',
'3BB0FD5DF8834078AE79602945438FB0',
'9D2D66BC3E4445AB989600388EC95158',
'97550D2E1E9F415EB2639228300E7132',
'3E942E807B3E43478370CE71C62F72F2',
'F9B7DE0C6EB54820A8324342CF7F12DA',
'15016F9D0E7E416DAFEC2E60DA28F0B6',
'DA1974494E2E4D629037F1B3E3C7B8D5',
'367A5FDAA0CB48668D9A4421999E6DE2',
'EFD05B0D61924ADF9901367D1BE13E09',
'EC5511646E9E4D90B16965B9E08050E1',
'A9C816E0BB87486296B25C12EB790057',
'95EBFA45929A454E9E222F09B09B8DAB',
'72BE0F6E1ADC4FEDAAB8269287537FFC',
'5FE159EB2CA043168D93E63701254CF7',
'0585673B87C64BF3A6299EF445F4F069',
'861764BAD1354F128F2B0D1C90B12F48')