Operation Details
Description: Returns the count of alias texts for the given determination delivery id and alias type
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :count 
FROM
  QuestionnaireVersion,
  Question,
  DPQuestionnaireLink,
  DeterminationDelivery,
  QuestionAlias 
WHERE DeterminationDelivery.determinationDeliveryID = :determinationDeliveryID 
  AND DPQuestionnaireLink.determinationPackageVersionID = DeterminationDelivery.determinationPackageVersionID 
  AND Question.questionnaireVersionID = DPQuestionnaireLink.questionnaireVersionID 
  AND QuestionnaireVersion.questionnaireVersionID = Question.questionnaireVersionID 
  AND QuestionAlias.questionID = Question.questionID 
  AND QuestionAlias.type = :aliasType