<mysql_data>
</mysql_data>
<fbsql_data dest_pharm_id="0">
/*
<nzok_update_date>16.06.2025</nzok_update_date> 
<fix_index>1</fix_index> 
<comment>Отпадащи НЗОК кодове от следващ период</comment> 
*/
UPDATE AXP_ENV_VARS SET VAR_VALUE = '16.06.2025' WHERE VAR_NAME = 'NZOKInactiveAfterPrescriptionDate';
DELETE FROM NZOK_INACTIVE_AFTER_DATE;
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF023');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF070');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF145');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF507');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CF806');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG355');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG356');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG867');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('CG942');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('JF571');
INSERT INTO NZOK_INACTIVE_AFTER_DATE (NZOK_CODE) VALUES ('RF198');
INSERT INTO AXP_ENV_VARS (ID, VAR_NAME, VAR_VALUE)
  SELECT FIRST 1 GEN_ID(AXP_ENV_VARS_ID, 1), 'ESignUsageCheckAfterDate', '10.08.2025'
  FROM AXP_ENV_VARS
  WHERE NOT EXISTS(
    SELECT ID
    FROM AXP_ENV_VARS
    WHERE (VAR_NAME = 'ESignUsageCheckAfterDate')
    );

update axp_env_vars av1 set av1.VAR_VALUE = '10.08.2025' where (av1.VAR_NAME = 'ESignUsageCheckAfterDate');
</fbsql_data>