SELECT
PDAssessmentConfiguration.pdAssessmentConfigurationID,
PDAssessmentConfiguration.assessmentConfigurationID,
AssessmentConfiguration.name,
PDAssessmentConfiguration.startDate,
PDAssessmentConfiguration.endDate,
PDAssessmentConfiguration.recordStatus
INTO
:pdAssessmentConfigurationID,
:assessmentConfigurationID,
:assessmentName,
:startDate,
:endDate,
:recordStatus
FROM
PDAssessmentConfiguration,
AssessmentConfiguration
WHERE PDAssessmentConfiguration.assessmentConfigurationID = AssessmentConfiguration.assessmentConfigurationID
AND PDAssessmentConfiguration.productID = :productID
|