Operation Details
Description: Returns a list of distinct active assessment configurations, associated with an AdminIntegrated case.
Sterotype: nsmulti
SQL 
SELECT 
  DISTINCT 
    ICAssessmentConfiguration.assessmentConfigurationID,
    AssessmentConfiguration.name
  INTO
    :assessmentConfigurationID,
    :name
  FROM
    ICAssessmentConfiguration,
    AssessmentConfiguration
  WHERE 
    ICAssessmentConfiguration.assessmentConfigurationID = 
    AssessmentConfiguration.assessmentConfigurationID
  AND 
    ICAssessmentConfiguration.adminIntegratedCaseID = :adminIntegratedCaseID
  AND
  ICAssessmentConfiguration.recordStatus = :status