SELECT
  resolutionConfigurationID,
  resolution,
  creationDate
INTO
  :resolutionConfigurationID,
  :resolution,
  :creationDate 
FROM
  ResolutionConfiguration 
WHERE resolutionConfigurationID NOT IN 
  ( 
  SELECT
    resolutionConfigurationID 
  FROM
    IssueResolutionLink 
  WHERE issueConfigurationID = :issueConfigurationID 
    AND recordStatus = :recordStatus 
  )