Operation Details
Description: Returns a list of destination records that the case participant role is a nominee on and the bank account exists on the case nominee destination entity.
Sterotype: nsmulti
SQL 
SELECT
  CaseNomineeDestination.caseNomineeDestinationID,
  CaseNomineeDestination.caseNomineeID
INTO
  :caseNomineeDestinationID,
  :caseNomineeID 
FROM
  CaseNomineeDestination,
  CaseParticipantRole,
  CaseNominee 
WHERE CaseNomineeDestination.destinationID = :concernRoleBankAccountID 
  AND CaseNomineeDestination.destinationType = :destinationType 
  AND CaseNomineeDestination.statusCode = :statusCode 
  AND CaseNominee.caseNomineeID = CaseNomineeDestination.caseNomineeID 
  AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
  AND CaseParticipantRole.participantRoleID = :participantRoleID