SELECT
  caseID,
  participantRoleID,
  caseParticipantRoleID
INTO
  :caseID,
  :participantRoleID,
  :caseParticipantRoleID 
FROM
  CaseParticipantRole 
WHERE caseID = :caseID 
  AND typeCode = :typeCode 
  AND participantRoleID = :participantRoleID 
  AND recordStatus = :recordStatus 
  AND 
  (
    
    (
      toDate >= :fromDate 
      OR toDate IS NULL 
    ) 
    AND 
    (
      fromDate <= :toDate 
      OR :toDate IS NULL 
    ) 
  )