BEGIN

DECLARE noDays, diffDays INT;

	IF (paidDate > dateGranted) OR ( paidDate <= maturityDate) THEN
		SET diffDays = DATEDIFF(paidDate,dateGranted);
		IF paymentTerm = "Weekly" THEN
			SET noDays = diffDays / 7;
		ELSEIF paymentTerm = "Semi Monthly" THEN
			SET noDays = diffDays / 15;
		ELSEIF paymentTerm = "Monthly" THEN
			SET noDays = diffDays / 30;
		END IF;
	END IF;
	RETURN TRUNCATE(noDays,0);
END