Operation Details
Description: Retrieves a list of assessment configuration that are on this screening configuration, independent of status or dates.
Sterotype: nsmulti
SQL 
SELECT
  AssessmentConfiguration.assessmentConfigurationID,
  ScreeningAssessmentConfig.scrAssConfigID,
  AssessmentConfiguration.name,
  ScreeningAssessmentConfig.startDate,
  ScreeningAssessmentConfig.endDate,
  ScreeningAssessmentConfig.recordStatus
INTO
  :assessmentConfigurationID,
  :scrAssConfigID,
  :assessmentName,
  :startDate,
  :endDate,
  :recordStatus 
FROM
  ScreeningAssessmentConfig,
  AssessmentConfiguration 
WHERE ScreeningAssessmentConfig.assessmentConfigurationID = AssessmentConfiguration.assessmentConfigurationID 
  AND ScreeningAssessmentConfig.screeningConfigID = :screeningConfigID