Operation Details
Description: gets the case participant role id, the case id and the case reference based on a case participant role id value
Sterotype: ns
SQL 
SELECT
  CaseParticipantRole.caseID,
  CaseParticipantRole.participantRoleID,
  CaseHeader.caseReference
INTO
  :caseID,
  :participantRoleID,
  :caseReference 
FROM
  CaseParticipantRole,
  CaseHeader 
WHERE CaseParticipantRole.caseParticipantRoleID = :caseParticipantRoleID 
  AND CaseHeader.caseID = CaseParticipantRole.caseID