SELECT
  DISTINCT CPR.participantRoleID
INTO
  :recordID 
FROM
  CaseNominee CN,
  CaseParticipantRole CPR,
  InstructionLineItem ILI 
WHERE CN.caseParticipantRoleID = CPR.caseParticipantRoleID 
  AND ILI.caseNomineeID = CN.caseNomineeID 
  AND ILI.statusCode = :statusCode