Operation Details
Description: search for Active provisions with the same provider, the same product and overlapping period
Sterotype: ns
SQL 
SELECT
  productProvisionID,
  startDate,
  endDate
INTO
  :productProvisionID,
  :startDate,
  :endDate 
FROM
  ProductProvision 
WHERE :statusCode = statusCode 
  AND 
  (
    :productID = productID 
  ) 
  AND 
  (
    :productProviderID = providerConcernRoleID 
  ) 
  AND 
  (
    
    (
      :endDate >= startDate 
      OR :endDate IS NULL 
    ) 
    AND 
    (
      :startDate <= endDate 
      OR endDate IS NULL 
    ) 
  )