CREATE PROCEDURE spdbCommissionDetail
(
    @TransactionInternalNo INT
)
AS
SET NOCOUNT ON
BEGIN

  DELETE FROM CommissionDetail
  WHERE CommissionInternalNo = @TransactionInternalNo

  -- It is VALID if zero rows exist (already cleaned)
  RETURN (0)
END
