/* 16.09.2019 2 Отпадащи НЗОК връзки от следващ период */ UPDATE AXP_ENV_VARS SET VAR_VALUE = '16.09.2019' WHERE VAR_NAME = 'NZOKInactiveDrugDiseaseAfterPrescrDate'; DELETE FROM NZOK_INACTIVE_DRUG_DISEASE; INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF870', 'I11.0'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF870', 'I11.9'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF870', 'I12.0'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF870', 'I12.9'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF870', 'I13.0'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF870', 'I13.1'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF870', 'I13.2'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF870', 'I20.0'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF870', 'I20.8'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF871', 'I11.0'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF871', 'I11.9'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF871', 'I12.0'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF871', 'I12.9'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF871', 'I13.0'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF871', 'I13.1'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF871', 'I13.2'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF871', 'I20.0'); INSERT INTO NZOK_INACTIVE_DRUG_DISEASE (NZOK_CODE, MKB) VALUES ('CF871', 'I20.8');