Operation Details
Description: Reads a Product Provider Link by Product ID and Product Provider ID.
Sterotype: ns
SQL 
SELECT
  productProvisionID,
  startDate,
  endDate,
  creationDate,
  comments,
  statusCode,
  estimatedCost,
  productID,
  providerConcernRoleID,
  versionNo
INTO
  :productProvisionID,
  :startDate,
  :endDate,
  :creationDate,
  :comments,
  :statusCode,
  :estimatedCost,
  :productID,
  :providerConcernRoleID,
  :versionNo 
FROM
  ProductProvision 
WHERE productID = :productID 
  AND providerConcernRoleID = :providerConcernRoleID 
  AND statusCode = :statusCode 
  AND startDate <= :effectiveDate 
  AND 
  (
    endDate >= :effectiveDate 
    OR endDate IS NULL 
  )