Operation Details
Description:  
Sterotype: ns
SQL 
SELECT
  OverpaymentEvidence.overpaymentEvidenceID,
  OverpaymentEvidence.fromDate,
  OverpaymentEvidence.toDate,
  OverpaymentEvidence.reassessmentDate,
  OverpaymentEvidence.overpaymentAmount,
  OverpaymentEvidence.caseID,
  OverpaymentEvidence.relatedCaseID,
  OverpaymentEvidence.versionNo,
  CH1.caseReference,
  CH2.caseReference
INTO
  :overpaymentEvidenceID,
  :fromDate,
  :toDate,
  :reassessmentDate,
  :overpaymentAmount,
  :caseID,
  :relatedCaseID,
  :versionNo,
  :caseReference,
  :relatedCaseReference 
FROM
  OverpaymentEvidence,
  CaseHeader CH1,
  CaseHeader CH2 
WHERE OverpaymentEvidence.overpaymentEvidenceID = :overpaymentEvidenceID 
  AND CH1.caseID = OverpaymentEvidence.caseID 
  AND CH2.caseID = OverpaymentEvidence.relatedCaseID