Database SQL Operation: DeterminationDelivery.searchAnswers
Description: | |
Sterotype: | nsmulti |
SELECT DeterminationAnswer.questionID, answer, sourceID,
consolidationInd, DeterminationAnswer.recordStatus
INTO :questionID, :answer, :sourceID, :consolidationInd, :recordStatus
FROM DeterminationAnswer, Question
WHERE questionnaireVersionID = :questionnaireVersionID AND
Question.questionID = DeterminationAnswer.questionID AND
determinationDeliveryID = :determinationDeliveryID AND
thirdPartyInd = :thirdPartyInd
|