SELECT
  SOEvaluationCriterion.soEvaluationCriterionID,
  ServiceEvaluationCriterion.criterion,
  ServiceEvaluationCriterion.responseType,
  SOEvaluationCriterion.recordStatus
INTO
  :soEvaluationCriterionID,
  :criterion,
  :responseType,
  :recordStatus 
FROM
  SOEvaluationCriterion,
  ServiceEvaluationCriterion 
WHERE ServiceEvaluationCriterion.SERVICEEVALUATIONCRITERIONID = SOEvaluationCriterion.SERVICEEVALUATIONCRITERIONID 
  AND SOEvaluationCriterion.RECORDSTATUS = :recordStatus 
  AND SOEvaluationCriterion.SERVICEOFFERINGID = :serviceOfferingID 
  AND SOEvaluationCriterion.SOEVALUATIONCRITERIONID NOT IN 
  ( 
  SELECT
    SOPerformMsrEvalCrtLnk.SOEVALUATIONCRITERIONID 
  FROM
    SOPerformMsrEvalCrtLnk 
  WHERE SOPerformMsrEvalCrtLnk.RECORDSTATUS = :recordStatus 
    AND SOPerformMsrEvalCrtLnk.SOPERFORMANCEMEASURELINKID = :soPerformanceMeasureLinkID 
  )