| Operation Details |  |
| Description: | Function to retrieve the case participant role by legalstatusID and recordStatus. |
| Sterotype: | ns |
| SQL | |
SELECT LEGALSTATUSLINK.CASEPARTICIPANTROLEID INTO :caseParticipantRoleID FROM LEGALSTATUSLINK WHERE LEGALSTATUSLINK.LEGALSTATUSID = :legalStatusID AND LEGALSTATUSLINK.RECORDSTATUS = :recordStatusCode |