/* 16.08.2018 1 Отпадащи НЗОК кодове от следващ период */ UPDATE AXP_ENV_VARS SET VAR_VALUE = '16.08.2018' WHERE VAR_NAME = 'NZOKInactiveAfterPrescriptionDate'; DELETE FROM NZOK_INACTIVE_AFTER_DATE; INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF457'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG812'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF652'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG814'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG191'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG184'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF671'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF670'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF684'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF959'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG179'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF584'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF585'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('GF138'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('HF091'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('HF130'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('LF221'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF418'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG371'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG813'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG529'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG815'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG696'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG695'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG773'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG556'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG644');