SELECT
  PaymentInstrument.pmtInstrumentID,
  PaymentInstrument.effectiveDate,
  PaymentInstrument.deliveryMethodType,
  PaymentInstrument.amount,
  PaymentInstrument.reconcilStatusCode
INTO
  :pmtInstrumentID,
  :effectiveDate,
  :deliveryMethodType,
  :amount,
  :reconcilStatusCode 
FROM
  CaseParticipantRole,
  CaseNominee,
  PaymentInstrument 
WHERE CaseParticipantRole.participantRoleID = :concernRoleID 
  AND CaseParticipantRole.typeCode = :participantTypeCode 
  AND CaseNominee.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND PaymentInstrument.caseNomineeID = CaseNominee.caseNomineeID 
  AND PaymentInstrument.reconcilStatusCode = :reconcilStatusCode 
ORDER BY effectiveDate