/* 01.08.2024 1 Отпадащи НЗОК кодове от следващ период */ UPDATE AXP_ENV_VARS SET VAR_VALUE = '01.08.2024' WHERE VAR_NAME = 'NZOKInactiveAfterPrescriptionDate'; DELETE FROM NZOK_INACTIVE_AFTER_DATE; INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('AF273'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI191'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI192'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI266'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI271'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI359'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI462'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI495'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI609'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK191'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK192'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK266'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK270'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK359'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK462'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK495'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK607'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV075'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV317'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV318'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV366'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV369'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV484'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV488'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV640');