Operation Details
Description: This method retrieves third party question answer details for the given determination delivery ID and third party request id
Sterotype: nsmulti
SQL
SELECT
  Question.questionID,
  QuestionAlias.aliasText,
  QuestionnaireVersion.name,
  DeterminationAnswer.answer,
  DeterminationAnswer.thirdPartyInd
INTO
  :questionID,
  :questionText,
  :questionnaireName,
  :answer,
  :thirdPartyInd 
FROM
  QuestionnaireVersion,
  QuestionAlias,
  Question,
  ThirdPartyRequestQuestion 
  
  LEFT OUTER JOIN
  
  DeterminationAnswer 
  ON DeterminationAnswer.sourceID = ThirdPartyRequestQuestion.thirdPartyRequestID 
  AND DeterminationAnswer.questionID = ThirdPartyRequestQuestion.questionID 
WHERE ThirdPartyRequestQuestion.thirdPartyRequestID = :thirdPartyRequestID 
  AND Question.questionID = ThirdPartyRequestQuestion.questionID 
  AND QuestionnaireVersion.questionnaireVersionID = Question.questionnaireVersionID 
  AND QuestionAlias.questionID = Question.questionID