<mysql_data>
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 206.40, MAX_PRICE = 206.40 WHERE (NZOK_CODE = 'YF242');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 103.20, MAX_PRICE = 103.20 WHERE (NZOK_CODE = 'YF243');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 107.20, MAX_PRICE = 107.20 WHERE (NZOK_CODE = 'YF248');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 29.10, MAX_PRICE = 29.10 WHERE (NZOK_CODE = 'YF249');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 29.10, MAX_PRICE = 29.10 WHERE (NZOK_CODE = 'YF250');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 29.10, MAX_PRICE = 29.10 WHERE (NZOK_CODE = 'YF251');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 60.00, MAX_PRICE = 60.00 WHERE (NZOK_CODE = 'YF252');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 34.80, MAX_PRICE = 34.80 WHERE (NZOK_CODE = 'YF258');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 309.90, MAX_PRICE = 309.90 WHERE (NZOK_CODE = 'YF292');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 300.90, MAX_PRICE = 300.90 WHERE (NZOK_CODE = 'YF293');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 247.50, MAX_PRICE = 247.50 WHERE (NZOK_CODE = 'YF336');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 137.60, MAX_PRICE = 137.60 WHERE (NZOK_CODE = 'YF337');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 34.40, MAX_PRICE = 34.40 WHERE (NZOK_CODE = 'YF338');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 189.60, MAX_PRICE = 189.60 WHERE (NZOK_CODE = 'YF439');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 268.80, MAX_PRICE = 268.80 WHERE (NZOK_CODE = 'YF465');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 268.80, MAX_PRICE = 268.80 WHERE (NZOK_CODE = 'YF471');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 199.80, MAX_PRICE = 199.80 WHERE (NZOK_CODE = 'YF539');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 199.80, MAX_PRICE = 199.80 WHERE (NZOK_CODE = 'YF542');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 300.90, MAX_PRICE = 300.90 WHERE (NZOK_CODE = 'YF556');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 255.00, MAX_PRICE = 255.00 WHERE (NZOK_CODE = 'YF574');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 255.00, MAX_PRICE = 255.00 WHERE (NZOK_CODE = 'YF576');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 255.00, MAX_PRICE = 255.00 WHERE (NZOK_CODE = 'YF582');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 309.90, MAX_PRICE = 309.90 WHERE (NZOK_CODE = 'YF753');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 216.00, MAX_PRICE = 216.00 WHERE (NZOK_CODE = 'YF767');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 216.00, MAX_PRICE = 216.00 WHERE (NZOK_CODE = 'YF768');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 216.00, MAX_PRICE = 216.00 WHERE (NZOK_CODE = 'YF769');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 139.20, MAX_PRICE = 139.20 WHERE (NZOK_CODE = 'YF847');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 53.60, MAX_PRICE = 53.60 WHERE (NZOK_CODE = 'YF855');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 82.50, MAX_PATIENT_PRICE = 0.00 WHERE (NZOK_CODE = 'YF909');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 168.00, MAX_PRICE = 168.00 WHERE (NZOK_CODE = 'YG069');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 68.80, MAX_PRICE = 68.80 WHERE (NZOK_CODE = 'YG078');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 268.80, MAX_PRICE = 268.80 WHERE (NZOK_CODE = 'YG112');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 185.40, MAX_PRICE = 185.40 WHERE (NZOK_CODE = 'YG114');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 103.30, MAX_PRICE = 103.30 WHERE (NZOK_CODE = 'YG119');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 171.40, MAX_PRICE = 171.40 WHERE (NZOK_CODE = 'ZF038');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 113.60, MAX_PRICE = 113.60 WHERE (NZOK_CODE = 'ZF056');/*stmt_lim*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 201.60, MAX_PRICE = 201.60 WHERE (NZOK_CODE = 'ZF113');/*stmt_lim*/
</mysql_data>
<fbsql_data dest_pharm_id="0">
/*
<nzok_update_date>01.07.2021</nzok_update_date> 
<fix_index>3</fix_index> 
<comment>Корекция на 38 кода</comment> 
*/
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 206.40, MAX_PRICE = 206.40 WHERE (NZOK_CODE = 'YF242');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 206.40, MAX_PRICE = 206.40 WHERE (NZOK_CODE = 'YF242') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 103.20, MAX_PRICE = 103.20 WHERE (NZOK_CODE = 'YF243');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 103.20, MAX_PRICE = 103.20 WHERE (NZOK_CODE = 'YF243') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 107.20, MAX_PRICE = 107.20 WHERE (NZOK_CODE = 'YF248');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 107.20, MAX_PRICE = 107.20 WHERE (NZOK_CODE = 'YF248') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 29.10, MAX_PRICE = 29.10 WHERE (NZOK_CODE = 'YF249');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 29.10, MAX_PRICE = 29.10 WHERE (NZOK_CODE = 'YF249') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 29.10, MAX_PRICE = 29.10 WHERE (NZOK_CODE = 'YF250');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 29.10, MAX_PRICE = 29.10 WHERE (NZOK_CODE = 'YF250') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 29.10, MAX_PRICE = 29.10 WHERE (NZOK_CODE = 'YF251');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 29.10, MAX_PRICE = 29.10 WHERE (NZOK_CODE = 'YF251') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 60.00, MAX_PRICE = 60.00 WHERE (NZOK_CODE = 'YF252');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 60.00, MAX_PRICE = 60.00 WHERE (NZOK_CODE = 'YF252') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 34.80, MAX_PRICE = 34.80 WHERE (NZOK_CODE = 'YF258');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 34.80, MAX_PRICE = 34.80 WHERE (NZOK_CODE = 'YF258') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 309.90, MAX_PRICE = 309.90 WHERE (NZOK_CODE = 'YF292');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 309.90, MAX_PRICE = 309.90 WHERE (NZOK_CODE = 'YF292') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 300.90, MAX_PRICE = 300.90 WHERE (NZOK_CODE = 'YF293');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 300.90, MAX_PRICE = 300.90 WHERE (NZOK_CODE = 'YF293') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 247.50, MAX_PRICE = 247.50 WHERE (NZOK_CODE = 'YF336');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 247.50, MAX_PRICE = 247.50 WHERE (NZOK_CODE = 'YF336') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 137.60, MAX_PRICE = 137.60 WHERE (NZOK_CODE = 'YF337');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 137.60, MAX_PRICE = 137.60 WHERE (NZOK_CODE = 'YF337') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 34.40, MAX_PRICE = 34.40 WHERE (NZOK_CODE = 'YF338');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 34.40, MAX_PRICE = 34.40 WHERE (NZOK_CODE = 'YF338') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 189.60, MAX_PRICE = 189.60 WHERE (NZOK_CODE = 'YF439');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 189.60, MAX_PRICE = 189.60 WHERE (NZOK_CODE = 'YF439') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 268.80, MAX_PRICE = 268.80 WHERE (NZOK_CODE = 'YF465');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 268.80, MAX_PRICE = 268.80 WHERE (NZOK_CODE = 'YF465') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 268.80, MAX_PRICE = 268.80 WHERE (NZOK_CODE = 'YF471');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 268.80, MAX_PRICE = 268.80 WHERE (NZOK_CODE = 'YF471') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 199.80, MAX_PRICE = 199.80 WHERE (NZOK_CODE = 'YF539');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 199.80, MAX_PRICE = 199.80 WHERE (NZOK_CODE = 'YF539') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 199.80, MAX_PRICE = 199.80 WHERE (NZOK_CODE = 'YF542');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 199.80, MAX_PRICE = 199.80 WHERE (NZOK_CODE = 'YF542') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 300.90, MAX_PRICE = 300.90 WHERE (NZOK_CODE = 'YF556');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 300.90, MAX_PRICE = 300.90 WHERE (NZOK_CODE = 'YF556') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 255.00, MAX_PRICE = 255.00 WHERE (NZOK_CODE = 'YF574');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 255.00, MAX_PRICE = 255.00 WHERE (NZOK_CODE = 'YF574') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 255.00, MAX_PRICE = 255.00 WHERE (NZOK_CODE = 'YF576');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 255.00, MAX_PRICE = 255.00 WHERE (NZOK_CODE = 'YF576') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 255.00, MAX_PRICE = 255.00 WHERE (NZOK_CODE = 'YF582');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 255.00, MAX_PRICE = 255.00 WHERE (NZOK_CODE = 'YF582') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 309.90, MAX_PRICE = 309.90 WHERE (NZOK_CODE = 'YF753');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 309.90, MAX_PRICE = 309.90 WHERE (NZOK_CODE = 'YF753') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 216.00, MAX_PRICE = 216.00 WHERE (NZOK_CODE = 'YF767');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 216.00, MAX_PRICE = 216.00 WHERE (NZOK_CODE = 'YF767') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 216.00, MAX_PRICE = 216.00 WHERE (NZOK_CODE = 'YF768');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 216.00, MAX_PRICE = 216.00 WHERE (NZOK_CODE = 'YF768') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 216.00, MAX_PRICE = 216.00 WHERE (NZOK_CODE = 'YF769');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 216.00, MAX_PRICE = 216.00 WHERE (NZOK_CODE = 'YF769') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 139.20, MAX_PRICE = 139.20 WHERE (NZOK_CODE = 'YF847');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 139.20, MAX_PRICE = 139.20 WHERE (NZOK_CODE = 'YF847') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 53.60, MAX_PRICE = 53.60 WHERE (NZOK_CODE = 'YF855');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 53.60, MAX_PRICE = 53.60 WHERE (NZOK_CODE = 'YF855') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 82.50, MAX_PATIENT_PRICE = 0.00 WHERE (NZOK_CODE = 'YF909');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 82.50, MAX_PATIENT_PRICE = 0.00 WHERE (NZOK_CODE = 'YF909') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 168.00, MAX_PRICE = 168.00 WHERE (NZOK_CODE = 'YG069');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 168.00, MAX_PRICE = 168.00 WHERE (NZOK_CODE = 'YG069') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 68.80, MAX_PRICE = 68.80 WHERE (NZOK_CODE = 'YG078');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 68.80, MAX_PRICE = 68.80 WHERE (NZOK_CODE = 'YG078') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 268.80, MAX_PRICE = 268.80 WHERE (NZOK_CODE = 'YG112');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 268.80, MAX_PRICE = 268.80 WHERE (NZOK_CODE = 'YG112') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 185.40, MAX_PRICE = 185.40 WHERE (NZOK_CODE = 'YG114');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 185.40, MAX_PRICE = 185.40 WHERE (NZOK_CODE = 'YG114') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 103.30, MAX_PRICE = 103.30 WHERE (NZOK_CODE = 'YG119');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 103.30, MAX_PRICE = 103.30 WHERE (NZOK_CODE = 'YG119') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 171.40, MAX_PRICE = 171.40 WHERE (NZOK_CODE = 'ZF038');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 171.40, MAX_PRICE = 171.40 WHERE (NZOK_CODE = 'ZF038') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 113.60, MAX_PRICE = 113.60 WHERE (NZOK_CODE = 'ZF056');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 113.60, MAX_PRICE = 113.60 WHERE (NZOK_CODE = 'ZF056') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
UPDATE ARTICLE_NZOK SET REINBURSEMENT = 201.60, MAX_PRICE = 201.60 WHERE (NZOK_CODE = 'ZF113');
UPDATE NHIF_ART_NZOK_HIST SET REINBURSEMENT = 201.60, MAX_PRICE = 201.60 WHERE (NZOK_CODE = 'ZF113') AND (NHIF_PERIOD_ID = (SELECT NHIF_PERIOD_ID FROM SP_GENERATE_NHIF_PERIOD('01.07.2021', '15.07.2021')));
</fbsql_data>