Operation Details
Description: To get a list of financial instructions for a Concern Role.
Sterotype: nsmulti
SQL 
SELECT
  finInstructionID,
  typeCode,
  concernRoleID,
  statusCode,
  amount,
  effectiveDate,
  postingDate,
  creditDebitType,
  currencyTypeCode,
  currencyExchangeID,
  instrumentGenInd
INTO
  :finInstructionID,
  :typeCode,
  :concernRoleID,
  :statusCode,
  :amount,
  :effectiveDate,
  :postingDate,
  :creditDebitType,
  :currencyTypeCode,
  :currencyExchangeID,
  :instrumentGenInd 
FROM
  FinancialInstruction 
WHERE FinancialInstruction.concernRoleID = :concernRoleID 
  AND FinancialInstruction.statusCode = :statusCode 
  AND FinancialInstruction.effectiveDate >= :effectiveDateFrom 
  AND FinancialInstruction.effectiveDate <= :effectiveDateTo 
ORDER BY effectiveDate DESC