NCDS_Procedure/CALCUP30.sql

DROP PROCEDURE IF EXISTS `CALCUP30`;
delimiter ;;
CREATE PROCEDURE `CALCUP30`()
BEGIN
	START TRANSACTION;
	UPDATE AR_BS_BONUS_103_CALC_NET T1 
	SET T1.USER_TYPE = 30 
	WHERE
		USER_TYPE >= 10 
		AND DIRECTLY_UNDER >= 3;
	COMMIT;

END
;;