Operation Details
Description: Read the all the ICAssessmentConfigurationDtls by assessmentConfigurationId,adminIntegratedCaseID and recordStatus.
Sterotype: nsmulti
SQL 
SELECT 
  ICAssessmentConfiguration.icAssessmentConfigurationID,
  ICAssessmentConfiguration.assessmentConfigurationID,
  ICAssessmentConfiguration.adminIntegratedCaseID,
  ICAssessmentConfiguration.startDate,
  ICAssessmentConfiguration.endDate,
  ICAssessmentConfiguration.recordStatus  
INTO
  :icAssessmentConfigurationID,
  :assessmentConfigurationID,
  :adminIntegratedCaseID,
  :startDate,
  :endDate,
  :recordStatus  
FROM
  ICAssessmentConfiguration
WHERE 
  ICAssessmentConfiguration.assessmentConfigurationID = :assessmentConfigurationID
AND 
  ICAssessmentConfiguration.adminIntegratedCaseID = :adminIntegratedCaseID
AND
  ICAssessmentConfiguration.recordStatus = :recordStatus