SELECT
  Question.questionID,
  aliasText,
  name
INTO
  :questionID,
  :questionText,
  :questionnaireName 
FROM
  QuestionnaireVersion,
  Question,
  QuestionAlias,
  DeterminationAnswer 
WHERE DeterminationAnswer.determinationDeliveryID = :determinationDeliveryID 
  AND DeterminationAnswer.questionID = Question.questionID 
  AND Question.questionnaireVersionID = QuestionnaireVersion.questionnaireVersionID 
  AND QuestionAlias.questionID = Question.questionID 
  AND QuestionAlias.type = :aliasType 
  AND DeterminationAnswer.questionID NOT IN 
  ( 
  SELECT
    questionID 
  FROM
    DeterminationAnswer 
  WHERE determinationDeliveryID = :determinationDeliveryID 
    AND consolidationInd <> :consolidationInd 
  )