Operation Details
Description: Returns list of legal actions associated with a case.
Sterotype: nsmulti
SQL 
SELECT
  LEGALACTION.LEGALACTIONID,
  LEGALACTION.CASEID,
  LEGALACTION.STARTDATE,
  LEGALACTION.ENDDATE,
  LEGALACTION.STATUSCODE,
  ADMINLEGALACTION.LEGALACTIONNAMECODE
INTO
  :legalActionID,
  :legalActionCaseID,
  :startDate,
  :endDate,
  :statusCode,
  :name 
FROM
  LEGALACTION,
  ADMINLEGALACTION,
  CASEHEADER,
  CASERELATIONSHIP 
WHERE LEGALACTION.CONFIGLEGALACTIONID =ADMINLEGALACTION.LEGALACTIONID 
  AND CASEHEADER.CASEID =LEGALACTION.CASEID 
  AND CASEHEADER.CASEID = CASERELATIONSHIP.CASEID 
  AND CASERELATIONSHIP.RELATEDCASEID = :caseID