Operation Details
Description: Read the details of the relationship between a product and an assessment.
Sterotype: ns
SQL 
SELECT
  PDAssessmentConfiguration.pdAssessmentConfigurationID,
  PDAssessmentConfiguration.assessmentConfigurationID,
  PDAssessmentConfiguration.productID,
  AssessmentConfiguration.name,
  PDAssessmentConfiguration.startDate,
  PDAssessmentConfiguration.endDate,
  PDAssessmentConfiguration.recordStatus,
  PDAssessmentConfiguration.versionNo
INTO
  :pdAssessmentConfigurationID,
  :assessmentConfigurationID,
  :productID,
  :assessmentName,
  :startDate,
  :endDate,
  :recordStatus,
  :versionNo 
FROM
  PDAssessmentConfiguration,
  AssessmentConfiguration 
WHERE PDAssessmentConfiguration.assessmentConfigurationID = AssessmentConfiguration.assessmentConfigurationID 
  AND PDAssessmentConfiguration.pdAssessmentConfigurationID = :pdAssessmentConfigurationID