SELECT
AssessmentConfiguration.assessmentConfigurationID,
ScreeningAssessmentConfig.scrAssConfigID,
AssessmentConfiguration.name,
ScreeningAssessmentConfig.startDate,
ScreeningAssessmentConfig.endDate,
ScreeningAssessmentConfig.recordStatus,
ScreeningAssessmentConfig.versionNo
INTO
:assessmentConfigurationID,
:scrAssConfigID,
:assessmentName,
:startDate,
:endDate,
:recordStatus,
:versionNo
FROM
ScreeningAssessmentConfig,
AssessmentConfiguration
WHERE ScreeningAssessmentConfig.assessmentConfigurationID = AssessmentConfiguration.assessmentConfigurationID
AND ScreeningAssessmentConfig.screeningConfigID = :screeningConfigID
|