Operation Details
Description: This method reads the case status from the case header. The caseEvidenceTreeID is used to retrieve the caseID from the CaseEvidenceTree entity which in turn is used to read the caseStatus from the CaseHeader.
Sterotype: ns
SQL
SELECT
  CaseHeader.statusCode
INTO
  :statusCode 
FROM
  CaseEvidenceTree,
  CaseHeader 
WHERE CaseEvidenceTree.caseEvidenceTreeID = :caseEvidenceTreeID 
  AND CaseHeader.caseID = CaseEvidenceTree.caseID