Operation Details
Description: Read the all the InvCAssessmentConfigDtls by assessmentConfigurationId, investigationConfigID and recordStatus.
Sterotype: nsmulti
SQL 
SELECT
  InvCAssessmentConfig.invCAssessmentConfigID,
  InvCAssessmentConfig.assessmentConfigurationID,
  InvCAssessmentConfig.investigationConfigID,
  InvCAssessmentConfig.startDate,
  InvCAssessmentConfig.endDate,
  InvCAssessmentConfig.recordStatus
INTO
  :invCAssessmentConfigID,
  :assessmentConfigurationID,
  :investigationConfigID,
  :startDate,
  :endDate,
  :recordStatus 
FROM
  InvCAssessmentConfig 
WHERE InvCAssessmentConfig.assessmentConfigurationID = :assessmentConfigurationID 
  AND InvCAssessmentConfig.investigationConfigID = :investigationConfigID 
  AND InvCAssessmentConfig.recordStatus = :recordStatus