Operation Details |
Description: | Returns number of active participants in a legal action. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :numberOfRecords FROM CASEPARTICIPANTROLE, LEGALACTION WHERE CASEPARTICIPANTROLE.CASEID = LEGALACTION.CASEID AND CASEPARTICIPANTROLE.PARTICIPANTROLEID = :concernRoleID AND LEGALACTION.CONFIGLEGALACTIONID = :configLegalActionID AND LEGALACTION.STATUSCODE = :statusCode |