Operation Details
Description: Read Mandatory Questionnaire Names which has no answer provided
Sterotype: nsmulti
SQL 
SELECT
  QuestionnaireVersion.name
INTO
  :name 
FROM
  DPQuestionnaireLink,
  QuestionOutcomeMetaData,
  QuestionnaireVersion,
  DeterminationDelivery 
WHERE DeterminationDelivery.determinationDeliveryID = :determinationDeiliveryID 
  AND DPQuestionnaireLink.determinationPackageVersionID = DeterminationDelivery.determinationPackageVersionID 
  AND QuestionOutcomeMetaData.dpQuestionnaireLinkID = DPQuestionnaireLink.dpQuestionnaireLinkID 
  AND QuestionOutcomeMetaData.questionnairePresentationCode = :presentationStatusCode 
  AND QuestionnaireVersion.questionnaireVersionID = DPQuestionnaireLink.questionnaireVersionID 
  AND QuestionnaireVersion.name NOT IN 
  ( 
  SELECT
    QuestionnaireVersion.name 
  FROM
    DPQuestionnaireLink,
    Question,
    DeterminationAnswer,
    QuestionnaireVersion,
    DeterminationDelivery 
  WHERE DeterminationDelivery.determinationDeliveryID = :determinationDeiliveryID 
    AND DPQuestionnaireLink.determinationPackageVersionID = DeterminationDelivery.determinationPackageVersionID 
    AND Question.questionnaireVersionID = DPQuestionnaireLink.questionnaireVersionID 
    AND DeterminationAnswer.questionID = Question.questionID 
    AND DeterminationAnswer.determinationDeliveryID = DeterminationDelivery.determinationDeliveryID 
    AND QuestionnaireVersion.questionnaireVersionID = Question.questionnaireVersionID 
  )