Operation Details
Description: Searches for all active case participant roles that a participant has on a Social Enterprise Folder.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT SocialEnterpriseFolder.caseID,
  SocialEnterpriseFolder.type,
  SocialEnterpriseFolder.sefAdminID,
  SocialEnterpriseFolder.outcome,
  SocialEnterpriseFolder.versionNo
INTO
  :caseID,
  :type,
  :sefAdminID,
  :outcome,
  :versionNo 
FROM
  SocialEnterpriseFolder,
  CaseParticipantRole 
WHERE 
  (
    CaseParticipantRole.participantRoleID = :participantRoleID 
    AND SocialEnterpriseFolder.caseID = CaseParticipantRole.caseID 
    AND CaseParticipantRole.recordStatus = :recordStatus 
  )