Operation Details
Description: Search for ILIs to be transferred in transfer batch process.
Sterotype: nsmulti
SQL 
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