UPDATE ARTICLE_NZOK AN SET AN.REINBURSEMENT = 3181.96, AN.MAX_PRICE = 3181.96, AN.MAX_PATIENT_PRICE = 795.49 WHERE AN.NZOK_CODE = 'LF253'; /* 01.03.2020 2 Подменена актуализация от страна на НЗОК */ UPDATE ARTICLE_NZOK AN SET AN.REINBURSEMENT = 3181.96, AN.MAX_PRICE = 3181.96, AN.MAX_PATIENT_PRICE = 795.49 WHERE AN.NZOK_CODE = 'LF253'; UPDATE NHIF_ART_NZOK_HIST NANH SET NANH.REINBURSEMENT = 3181.96, NANH.MAX_PRICE = 3181.96, NANH.MAX_PATIENT_PRICE = 795.49 WHERE (NANH.NZOK_CODE = 'LF253') AND (NANH.NHIF_PERIOD_ID = ( SELECT FIRST 1 NP.ID FROM NHIF_PERIOD NP WHERE (NP.START_DATE = '01.03.2020') AND (NP.END_DATE = '15.03.2020')) );