Database SQL Operation: LegalAction.countActiveLegalActionsByCaseID
| Description: | <span lang="EN-IE"
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-ansi-language: EN-IE; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Counts
the active Legal Actions associated with a case.</span> |
| Sterotype: | ns |
SELECT
COUNT(*)
INTO
:numberOfRecords
FROM
CaseRelationship,
LegalAction
WHERE
CaseRelationship.typeCode = :relationShipCode AND
CaseRelationship.relatedCaseID = :caseID AND
LegalAction.caseID = CaseRelationship.caseID AND
LegalAction.statusCode = :statusCode
|
