Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  HearingParticipation.hearingParticipationID,
  HearingParticipation.caseParticipantRoleID,
  CaseParticipantRole.participantRoleID,
  HearingParticipation.versionNo,
  ConcernRole.concernRoleName,
  HearingParticipation.participatedCode,
  CaseParticipantRole.typeCode,
  HearingParticipation.caseID
INTO
  :hearingParticipationID,
  :caseParticipantRoleID,
  :participantRoleID,
  :versionNo,
  :fullName,
  :participatedCode,
  :participantType,
  :caseID 
FROM
  HearingParticipation,
  CaseParticipantRole,
  ConcernRole 
WHERE HearingParticipation.hearingID = :hearingID 
  AND CaseParticipantRole.recordStatus = :recordStatus 
  AND HearingParticipation.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID 
  AND CaseParticipantRole.typeCode = :participantType