Database SQL Operation: PDAssessmentConfiguration.searchDistinctAssessmentConfigByAdminIntegratedCase
| Description: | Returns a list of distinct active assessment configurations, associated with an product case configuration. |
| Sterotype: | nsmulti |
SELECT
DISTINCT PDAssessmentConfiguration.assessmentConfigurationID,
AssessmentConfiguration.name
INTO
:assessmentConfigurationID,
:name
FROM
PDAssessmentConfiguration,
AssessmentConfiguration
WHERE PDAssessmentConfiguration.assessmentConfigurationID = AssessmentConfiguration.assessmentConfigurationID
AND PDAssessmentConfiguration.productID = :productID
AND PDAssessmentConfiguration.recordStatus = :status
|
