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 |