Operation Details
Description: Function to retrieve the legal status of a concern role by case participant role id.
Sterotype: ns
SQL 
SELECT
  LEGALSTATUS.LEGALSTATUSID,
  LEGALSTATUS.CONFIGLEGALSTATUSID,
  ADMINLEGALSTATUS.LEGALSTATUSTYPECODE,
  LEGALSTATUS.STARTDATE,
  LEGALSTATUS.ENDDATE
INTO
  :legalStatusID,
  :configLegalStatusID,
  :legalStatusCode,
  :startDate,
  :endDate 
FROM
  LEGALSTATUSLINK,
  LEGALSTATUS,
  ADMINLEGALSTATUS 
WHERE LEGALSTATUSLINK.LEGALSTATUSID =LEGALSTATUS.LEGALSTATUSID 
  AND LEGALSTATUS.CONFIGLEGALSTATUSID =ADMINLEGALSTATUS.LEGALSTATUSID 
  AND LEGALSTATUSLINK.CASEPARTICIPANTROLEID = :caseParticipantRoleID