Operation Details
Description: search all the third parties for an appeal case.
Sterotype: nsmulti
SQL 
SELECT
  ThirdParty.thirdPartyID,
  ThirdParty.thirdPartyType,
  ThirdParty.fromDate,
  ThirdParty.toDate,
  ThirdParty.attendanceRequired,
  ConcernRole.concernRoleName,
  ConcernRole.concernRoleID,
  ThirdParty.caseParticipantRoleID
INTO
  :thirdPartyID,
  :thirdPartyTypeCode,
  :fromDate,
  :toDate,
  :attendanceRequired,
  :thirdPartyName,
  :concernRoleID,
  :caseParticipantRoleID 
FROM
  ThirdParty ThirdParty,
  CaseParticipantRole CaseParticipantRole,
  ConcernRole ConcernRole 
WHERE appealID = :appealID 
  AND ThirdParty.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND participantRoleID = concernRoleID