<mysql_data>
</mysql_data>
<fbsql_data dest_pharm_id="0">
/*
<nzok_update_date>25.08.2022</nzok_update_date> 
<fix_index>3</fix_index> 
<comment>Корекция на връзки Лекарство-МКБ-Възраст</comment> 
*/
DELETE
from NHIF_DRUG_DIS_AGE_HIST NDDAH
WHERE NDDAH.NHIF_PERIOD_ID IN
(SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP)
  AND (
    ((NDDAH.NZOK_CODE='NF652') AND (NDDAH.MKB='G40.6')) OR
    ((NDDAH.NZOK_CODE='NF652') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF653') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF653') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF654') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF654') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF655') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF655') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF978') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF978') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF979') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF979') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF980') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF980') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF981') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF981') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF982') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF982') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF983') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF983') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NF984') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NF984') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NG002') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NG002') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NG003') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NG003') AND (NDDAH.MKB='G40.7')) OR 
    ((NDDAH.NZOK_CODE='NG004') AND (NDDAH.MKB='G40.6')) OR 
    ((NDDAH.NZOK_CODE='NG004') AND (NDDAH.MKB='G40.7'))
  );
  
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF652', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF652', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF653', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF653', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF654', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF654', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF655', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF655', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF978', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF978', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF979', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF979', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF980', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF980', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF981', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF981', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF982', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF982', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF983', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF983', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NF984', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NF984', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NG002', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NG002', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NG003', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NG003', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.6', 'NG004', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
INSERT INTO NHIF_DRUG_DIS_AGE_HIST (ID, MKB, NZOK_CODE, MIN_AGE, MAX_AGE, NHIF_PERIOD_ID) VALUES (GEN_ID(NHIF_DRUG_DIS_AGE_HIST_ID, 1), 'G40.7', 'NG004', 48, 2400, (SELECT SP.NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('16.08.2022', '31.08.2022') SP));
</fbsql_data>