DROP PROCEDURE IF EXISTS `QTRCLEAN`;
delimiter ;;
CREATE PROCEDURE `QTRCLEAN`(IN `PCPID` INT)
BEGIN-- 删除当期奖金
	DELETE 
	FROM
		AR_CALC_BONUS_QUARTER
	WHERE
		PERIOD_NUM >= PCPID;
  TRUNCATE
		AR_QTR_CALC_USER;
	TRUNCATE
		AR_QTR_CALC_WEIGHT;
	TRUNCATE
		AR_QTR_CALC_SCORE;
END
;;