Operation Details
Description: Searches and returns a list of payment financial instructions based on the concernrole and case nominee.
Sterotype: nsmulti
SQL 
SELECT PAYMENTINSTRUCTION.FININSTRUCTIONID,
FINANCIALINSTRUCTION.TYPECODE,
PAYMENTINSTRUCTION.DELIVERYMETHODTYPE,
PAYMENTINSTRUCTION.CASENOMINEEID,
PAYMENTINSTRUCTION.AMOUNT,
CONCERNROLE.CONCERNROLEID
INTO
:finInstructionID, :typeCode, :deliveryMethodType, :caseNomineeID, :amount, :concernRoleID
FROM PAYMENTINSTRUCTION,CASENOMINEE,CASEPARTICIPANTROLE,
CONCERNROLE,FINANCIALINSTRUCTION
WHERE PAYMENTINSTRUCTION.CASENOMINEEID = CASENOMINEE.CASENOMINEEID
AND CASEPARTICIPANTROLE.CASEPARTICIPANTROLEID = CASENOMINEE.CASEPARTICIPANTROLEID
AND CONCERNROLE.CONCERNROLEID = CASEPARTICIPANTROLE.PARTICIPANTROLEID
AND PAYMENTINSTRUCTION.FININSTRUCTIONID = FINANCIALINSTRUCTION.FININSTRUCTIONID
AND CONCERNROLE.CONCERNROLEID=:concernRoleID