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