Operation Details
Description: Returns a list of all legal actions and legal categories details.
Sterotype: nsmulti
SQL 
SELECT
  ADMINLEGALACTIONCATEGORY.LEGALACTIONCATEGORYID,
  ADMINLEGALACTIONCATEGORY.LEGALCATEGORYNAMECODE,
  ADMINLEGALACTION.LEGALACTIONID,
  ADMINLEGALACTION.LEGALACTIONNAMECODE,
  LEGALCASETYPELINK.ASSOCIATEDCASETYPE,
  LEGALCASETYPELINK.RELATEDID
INTO
  :legalCategoryID,
  :legalCategoryNameCode,
  :legalActionID,
  :legalActionNameCode ,
  :associatedCaseType ,
  :relatedID 
FROM
  ADMINLEGALACTION,
  ADMINLEGALACTIONCATEGORY,
  ADMINLEGALACTIONLINK ,
  LEGALCASETYPELINK 
WHERE ADMINLEGALACTION.LEGALACTIONID =ADMINLEGALACTIONLINK.LEGALACTIONID 
  AND ADMINLEGALACTIONCATEGORY.LEGALACTIONCATEGORYID =ADMINLEGALACTIONLINK.LEGALACTIONCATEGORYID 
  AND LEGALCASETYPELINK.CONFIGLEGALACTIONID = ADMINLEGALACTION.LEGALACTIONID 
  AND LEGALCASETYPELINK.CONFIGLEGALACTIONID =ADMINLEGALACTIONLINK.LEGALACTIONID 
  AND ADMINLEGALACTION.ENDDATE IS NULL