Database SQL Operation: DeterminationConfig.searchAssociatedDCsForAssessment
Description: | This method is used to read all the determinations which has the given status and associated to the given Assessment Configuration |
Sterotype: | nsmulti |
SELECT
determinationConfigID,
name,
standAlone
INTO
:determinationConfigID,
:name,
:standAlone
FROM
DeterminationConfig DC
WHERE EXISTS
(
SELECT
determinationConfigID
FROM
DetAssessmentConfigLink
WHERE DC.determinationConfigID = DetAssessmentConfigLink.determinationConfigID
AND assessmentConfigurationID = :assessmentConfigurationID
AND recordStatus = :recordStatus
)
ORDER BY name
|