Operation Details
Description: Retrieves details for the specified Screening Assessment relationship.
Sterotype: ns
SQL 
SELECT
  ScreeningConfiguration.name,
  AssessmentConfiguration.name,
  ScreeningAssessmentConfig.startDate,
  ScreeningAssessmentConfig.endDate,
  ScreeningAssessmentConfig.scrAssConfigID,
  ScreeningAssessmentConfig.recordStatus,
  ScreeningAssessmentConfig.versionNo
INTO
  :screeningConfigurationName,
  :assessmentConfigurationName,
  :startDate,
  :endDate,
  :scrAssConfigID,
  :recordStatus,
  :versionNo 
FROM
  ScreeningConfiguration,
  ScreeningAssessmentConfig,
  AssessmentConfiguration 
WHERE :scrAssConfigID = ScreeningAssessmentConfig.scrAssConfigID 
  AND ScreeningConfiguration.screeningConfigID = ScreeningAssessmentConfig.screeningConfigID 
  AND AssessmentConfiguration.assessmentConfigurationID = ScreeningAssessmentConfig.assessmentConfigurationID