<mysql_data>
</mysql_data>
<fbsql_data dest_pharm_id="0">
/*
<nzok_update_date>01.01.2024</nzok_update_date> 
<fix_index>1</fix_index> 
<comment>Отпадащи НЗОК кодове от следващ период</comment> 
*/
UPDATE AXP_ENV_VARS SET VAR_VALUE = '01.01.2024' WHERE VAR_NAME = 'NZOKInactiveAfterPrescriptionDate';
DELETE FROM NZOK_INACTIVE_AFTER_DATE;
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('WF121');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('WF122');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('WF126');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF790');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('YF943');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF148');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF149');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF150');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF151');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF152');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF179');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF180');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF181');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF182');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF183');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF111');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF112');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF113');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF267');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF268');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF269');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF270');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF271');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF272');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF273');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF274');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF275');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF276');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF204');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF205');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('ZF206');
</fbsql_data>