Operation Details
Description: To retrieve the legal status details of a concern role by concern role id.
Sterotype: ns
SQL 
SELECT
  LEGALSTATUS.LEGALSTATUSID,
  LEGALSTATUS.CONFIGLEGALSTATUSID,
  ADMINLEGALSTATUS.LEGALSTATUSTYPECODE,
  LEGALSTATUS.STARTDATE,
  LEGALSTATUS.ENDDATE
INTO
  :legalStatusID,
  :configLegalStatusID,
  :legalStatusCode,
  :startDate,
  :endDate 
FROM
  LEGALSTATUS,
  ADMINLEGALSTATUS 
WHERE LEGALSTATUS.CONFIGLEGALSTATUSID =ADMINLEGALSTATUS.LEGALSTATUSID 
  AND LEGALSTATUS.CONCERNROLEID = :concernRoleID 
  AND LEGALSTATUS.RECORDSTATUSCODE ='RST1'