<mysql_data>
</mysql_data>
<fbsql_data dest_pharm_id="0">
/*
<nzok_update_date>16.09.2020</nzok_update_date> 
<fix_index>1</fix_index> 
<comment>Отпадащи НЗОК кодове от следващ период</comment> 
*/
UPDATE AXP_ENV_VARS SET VAR_VALUE = '16.09.2020' WHERE VAR_NAME = 'NZOKInactiveAfterPrescriptionDate';
DELETE FROM NZOK_INACTIVE_AFTER_DATE;
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('AF413');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF617');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF751');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG357');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG358');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF820');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG413');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF644');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF643');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG475');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG473');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF547');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG557');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF552');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF553');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF587');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG664');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG662');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG661');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG139');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF832');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG636');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF711');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF710');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF712');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('LF270');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('MF117');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF951');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF968');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF881');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF241');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('NF880');
</fbsql_data>