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