/* 01.07.2026 1 Отпадащи НЗОК кодове от следващ период */ UPDATE AXP_ENV_VARS SET VAR_VALUE = '01.07.2026' WHERE VAR_NAME = 'NZOKInactiveAfterPrescriptionDate'; DELETE FROM NZOK_INACTIVE_AFTER_DATE; INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI388'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CI676'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK388'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CK675'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV148'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CV722'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('MI076'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('MI077'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('MK076'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('MK077'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('MV028'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('MV029'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NI011'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NK011'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NV019'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('UK002'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('UT002'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('WF123'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('WF124'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('WF132'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('WF133'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF182'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF196'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF197'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF210'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF212'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF218'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF230'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF231'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF248'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF258'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF324'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF325'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF337'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF338'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF357'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF358'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF359'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF463'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF470'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF473'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF536'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF814'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG058'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG059'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG108'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG109'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG121'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG155'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG327'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG332'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG338'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG381'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG383'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG386'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG394'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG398'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG399'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG401'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG402'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG404'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG405'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG406'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG407'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG409'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG411'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG418'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG419'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG423'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG424'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG425'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YG427'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF153'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF154'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF156'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF157'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF158'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF190'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF191'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF192'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF193'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF194'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF195'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF196'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF197'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF198'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF199'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF200'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF201'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF202'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF226'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF227'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF228'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF229'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF230'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF231'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF232'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF233'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF234'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF235'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF236'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF237'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF238'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF239'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF240'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF241'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF242'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF243'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF244'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF245'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF246'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF247'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF248'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF249'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF250'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF251'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF252'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF253'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF254'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF255'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF256'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF257'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF302'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF303'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF304'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF305'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF306'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF307'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF308'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF309'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF310'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF311'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF312'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF313'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF314'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF320'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF321'); INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF322');