Database SQL Operation: QuestionnaireVersion.searchQuestionnaireForPackageByStatus
Description: | Reads questionnaire version ID and name based on determination package and status |
Sterotype: | nsmulti |
SELECT
QuestionnaireVersion.questionnaireVersionID,
QuestionnaireVersion.name
INTO
:questionnaireVersionID,
:name
FROM
QuestionnaireVersion,
DPQuestionnaireLink
WHERE QuestionnaireVersion.questionnaireVersionID = DPQuestionnaireLink.questionnaireVersionID
AND determinationPackageVersionID = :determinationPackageVersionID
AND QuestionnaireVersion.versionStatus = :versionStatus
|