Operation Details
Description: function to read all provider location that have not been assigned to the given product provision
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT ProviderLocation.providerLocationID,
  ProviderLocation.name,
  ProviderLocation.statusCode,
  ProviderLocation.startDate,
  ProviderLocation.endDate
INTO
  :providerLocationID,
  :name,
  :statusCode,
  :startDate,
  :endDate 
FROM
  ProviderLocation 
WHERE :productProviderID = ProviderLocation.productProviderID 
  AND ProviderLocation.statusCode = :statusCode 
  AND ProviderLocation.providerLocationID NOT in 
  ( 
  SELECT
    providerLocationID 
  FROM
    ProvisionLocation 
  WHERE ProvisionLocation.productProvisionID = :productProvisionID 
  )