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