/* 16.07.2018 1 Отпадащи НЗОК кодове от следващ период */ UPDATE AXP_ENV_VARS SET VAR_VALUE = '16.07.2018' WHERE VAR_NAME = 'NZOKInactiveAfterPrescriptionDate'; DELETE FROM NZOK_INACTIVE_AFTER_DATE; INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('AF400'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('AF401'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('AF498'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF459'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF797'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG107'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG108'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG109'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG140'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG383'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG430'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG442'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG444'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG653'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG655'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF677'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('SF137');