The scope of a single-record constraint is restricted to the columns of 1 table. In the constraint SQL you use a single table name in the FROM clause.
Consider the business rule: "A reservation can only be canceled after the reservation is booked." This rule is implemented by a restrictive single-record constraint:
SELECT '' violation
The Rules Engine validates single-record constraints at record validation time, when the record is stored. Corrective single-record constraints are validated before restrictive single-record constraints.