SELECT
QuestionnaireVersion.name,
questionText,
Question.questionID,
answer,
codeTableInd,
Question.type
INTO
:questionnaireName,
:questionText,
:questionID,
:answer,
:codeTableInd,
:type
FROM
DEBaseline,
QuestionnaireVersion,
Question,
DeterminationDecision
WHERE DeterminationDecision.determinationDecisionID = :determinationDecisionID
AND DEBaseline.determinationExecutionID = DeterminationDecision.determinationExecutionID
AND consolidationInd = :consolidationInd
AND Question.questionID = DEBaseline.questionID
AND QuestionnaireVersion.questionnaireVersionID = Question.questionnaireVersionID
|