SELECT
  LEGALSTATUS.LEGALSTATUSID,
  LEGALSTATUS.CONFIGLEGALSTATUSID,
  LEGALSTATUS.CONCERNROLEID,
  LEGALSTATUS.LEGALACTIONID,
  LEGALSTATUS.STARTDATE,
  LEGALSTATUS.ENDDATE,
  LEGALSTATUS.RECORDSTATUSCODE
INTO
  :legalStatusID,
  :configLegalStatusID,
  :concernRoleID,
  :legalActionID,
  :startDate,
  :endDate,
  :recordStatusCode 
FROM
  LEGALSTATUS,
  LEGALSTATUSLINK 
WHERE LEGALSTATUS.legalStatusID =LEGALSTATUSLINK.legalStatusID 
  AND LEGALSTATUSLINK.CASEPARTICIPANTROLEID = :caseParticipantRoleID