Operation Details
Description: Read the details of the relationship between an integrated case and an assessment.
Sterotype: ns
SQL 
SELECT
  AdminIntegratedCase.integratedCaseType,
  AssessmentConfiguration.name,
  ICAssessmentConfiguration.startDate,
  ICAssessmentConfiguration.endDate,
  ICAssessmentConfiguration.icAssessmentConfigurationID,
  ICAssessmentConfiguration.adminIntegratedCaseID,
  ICAssessmentConfiguration.assessmentConfigurationID,
  ICAssessmentConfiguration.recordStatus,
  ICAssessmentConfiguration.versionNo
INTO
  :integrateCaseConfigurationName,
  :assessmentConfigurationName,
  :startDate,
  :endDate,
  :icAssessmentConfigurationID,
  :adminIntegratedCaseID,
  :assessmentConfigurationID,
  :recordStatus,
  :versionNo 
FROM
  AdminIntegratedCase,
  ICAssessmentConfiguration,
  AssessmentConfiguration 
WHERE ICAssessmentConfiguration.icAssessmentConfigurationID = :icAssessmentConfigurationID 
  AND AdminIntegratedCase.adminIntegratedCaseID = ICAssessmentConfiguration.adminIntegratedCaseID 
  AND AssessmentConfiguration.assessmentConfigurationID = ICAssessmentConfiguration.assessmentConfigurationID