/* 16.04.2020 1 Отпадащи НЗОК кодове от следващ период */ UPDATE AXP_ENV_VARS SET VAR_VALUE = '16.04.2020' WHERE VAR_NAME = 'NZOKInactiveAfterPrescriptionDate'; DELETE FROM NZOK_INACTIVE_AFTER_DATE; INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG118'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG119'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG693'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG694'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF664'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG667'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF681'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG735'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG734'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF732'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('LF217'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF537'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF535'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF534'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF536'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF001'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG189'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF671');