Database SQL Operation: ICAssessmentConfiguration.searchIntegratedCaseTypesByAssessmentConfiguration
Description: | This method list admin integrated cases that are associated to an assessment configuration. |
Sterotype: | nsmulti |
SELECT
AdminIntegratedCase.adminIntegratedCaseID,
AdminIntegratedCase.integratedCaseType,
AdminIntegratedCase.homePageName,
ICAssessmentConfiguration.startDate,
ICAssessmentConfiguration.endDate,
AdminIntegratedCase.statusCode
INTO
:adminIntegratedCaseID,
:integratedCaseType,
:homePageName,
:startDate,
:endDate,
:statusCode
FROM
AdminIntegratedCase,
ICAssessmentConfiguration
WHERE ICAssessmentConfiguration.assessmentConfigurationID= :assessmentConfigurationID
AND
AdminIntegratedCase.adminIntegratedCaseID = ICAssessmentConfiguration.adminIntegratedCaseID
|