Operation Details
Description: Returns all the legal actions for a case participant.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT LEGALACTION.LEGALACTIONID,
  LEGALACTION.CONFIGLEGALACTIONID,
  ADMINLEGALACTION.LEGALACTIONNAMECODE
INTO
  :legalActionID,
  :configLegalActionID,
  :legalActionNameCode 
FROM
  LEGALACTION,
  ADMINLEGALACTION,
  CONCERNROLE,
  CASEHEADER,
  CASERELATIONSHIP 
WHERE LEGALACTION.CONFIGLEGALACTIONID = ADMINLEGALACTION.LEGALACTIONID 
  AND CASEHEADER.CASEID = LEGALACTION.CASEID 
  AND CASERELATIONSHIP.CASEID = CASEHEADER.CASEID 
  AND CASERELATIONSHIP.RELATEDCASEID = :caseID 
  AND CASERELATIONSHIP.TYPECODE = :relationShipCode