
	SELECT * FROM beneficiaire 
	-- SET codeEtatBeneficiaire="SB", dateEtat=NOW()
	WHERE numeroBeneficiaire='0122004801'



	SELECT * FROM adherent 
	-- SET codeEtatBeneficiaire="SB", dateEtat=NOW()
	WHERE idPolice IN (195,172,157,154,122) 
	AND (codeEtatAdherent="V")  
	AND dateEffet>='2023-01-01'




	UPDATE adherent SET codeEtatAdherent="SB", dateEtat=NOW() 
	
	-- 1 SUSPENSION DES BENEFICIAIRES
	
	UPDATE beneficiaire 
	SET codeEtatBeneficiaire="SB", dateEtat=NOW()
	WHERE idPolice IN (195,172,157,154,122) 
	AND (codeEtatBeneficiaire="V")  
	AND dateEffet>='2023-01-01';	
	

	UPDATE adherent 
	SET codeEtatAdherent="SB", dateEtat=NOW()
	WHERE idPolice IN (195,172,157,154,122) 
	AND (codeEtatAdherent="V")  
	AND dateEffet>='2023-01-01';
	
	-- 2 REACTIVATION DES BENEFICIAIRES
	
	UPDATE beneficiaire 
	SET codeEtatBeneficiaire="V", dateEtat=NOW()
	WHERE numeroAdherent IN  ('01950007')
	-- WHERE idPolice IN (195,172,157,154,122) 
	AND (codeEtatBeneficiaire="SB")  
	AND dateEffet>='2023-01-01';	
	

	UPDATE adherent 
	SET codeEtatAdherent="V", dateEtat=NOW()
	WHERE numeroAdherent IN  ('01950007')
	-- WHERE idPolice IN (195,172,157,154,122) 
	AND (codeEtatAdherent="SB")  
	AND dateEffet>='2023-01-01';
	
	
	-- (A SUSPENDRE)

	
	UPDATE beneficiaire 
	SET codeEtatBeneficiaire="SB", dateEtat=NOW()
	WHERE numeroAdherent IN  ('01220051')
	-- WHERE idPolice IN (195,172,157,154,122) 
	AND (codeEtatBeneficiaire="V")  
	AND dateEffet>='2023-01-01';	
	

	UPDATE adherent 
	SET codeEtatAdherent="SB", dateEtat=NOW()
	WHERE numeroAdherent IN  ('01220051')
	-- WHERE idPolice IN (195,172,157,154,122) 
	AND (codeEtatAdherent="V")  
	AND dateEffet>='2023-01-01';
