Operation Details
Description: Read all the PDAssessmentConfigurationDtls by the assessmentConfigurationID, ProductID and record status
Sterotype: nsmulti
SQL 
SELECT
  PDAssessmentConfiguration.pdAssessmentConfigurationID,
  PDAssessmentConfiguration.productID,
  PDAssessmentConfiguration.assessmentConfigurationID,
  PDAssessmentConfiguration.startDate,
  PDAssessmentConfiguration.endDate,
  PDAssessmentConfiguration.recordStatus
INTO
  :pdAssessmentConfigurationID,
  :productID,
  :assessmentConfigurationID,
  :startDate,
  :endDate,
  :recordStatus 
FROM
  PDAssessmentConfiguration 
WHERE PDAssessmentConfiguration.assessmentConfigurationID = :assessmentConfigurationID 
  AND PDAssessmentConfiguration.productID = :productID 
  AND PDAssessmentConfiguration.recordStatus = :recordStatus