Database SQL Operation: InvCAssessmentConfig.searchDistinctAssessmentConfigByInvestigationCase
| Description: | Returns a list of distinct active assessment configurations, associated with an investigation case. |
| Sterotype: | nsmulti |
SELECT
DISTINCT InvCAssessmentConfig.assessmentConfigurationID,
AssessmentConfiguration.name
INTO
:assessmentConfigurationID,
:name
FROM
InvCAssessmentConfig,
AssessmentConfiguration
WHERE InvCAssessmentConfig.assessmentConfigurationID = AssessmentConfiguration.assessmentConfigurationID
AND InvCAssessmentConfig.investigationConfigID = :investigationConfigID
AND InvCAssessmentConfig.recordStatus = :status
|
