| Operation Details |  |
| Description: | Reads case reference details by related case ID and reason code. |
| Sterotype: | ns |
| SQL | |
SELECT CaseRelationship.caseID, CaseRelationship.startDate, CaseHeader.caseReference INTO :relatedCaseID, :startDate, :caseReference FROM CaseRelationship, CaseHeader WHERE CaseRelationship.relatedCaseID = :caseID AND CaseRelationship.reasonCode = :reasonCode AND CaseHeader.caseID = CaseRelationship.caseID |