Operation Details
Description: Entity operation to check for overlapping product time constraints, searching by product id, constraint type, status and date.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  ProductTimeConstraint ptc 
WHERE ptc.productID = :productID 
  AND ptc.constraintType = :constraintType 
  AND ptc.fromDate >= :fromDate 
  AND ptc.recordStatus = :recordStatus