SELECT
SOPerformMsrEvalCrtLnk.soPerformMsrEvalCrtLnkID,
ServiceEvaluationCriterion.serviceEvaluationCriterionID,
ServiceEvaluationCriterion.criterion,
ServiceEvaluationCriterion.responseType,
SOPerformMsrEvalCrtLnk.recordStatus,
SOPerformMsrEvalCrtLnk.versionNo
INTO
:soPerformMsrEvalCrtLnkID,
:serviceEvaluationCriterionID,
:criterion,
:responseType,
:status,
:versionNo
FROM
SOPerformMsrEvalCrtLnk,
ServiceEvaluationCriterion,
SOEvaluationCriterion
WHERE SOPerformMsrEvalCrtLnk.soPerformanceMeasureLinkID = :soPerformanceMeasureLinkID
AND SOEvaluationCriterion.soEvaluationCriterionID = SOPerformMsrEvalCrtLnk.soEvaluationCriterionID
AND ServiceEvaluationCriterion.serviceEvaluationCriterionID = SOEvaluationCriterion.serviceEvaluationCriterionID
|