Operation Details
Description: Reads the payment date for a financial instruction. The payment date is the latest due date on the instruction line items for an instruction.
Sterotype: ns
SQL 
SELECT
  MAX(InstructionLineItem.dueDate),
  MIN(InstructionLineItem.coverPeriodFrom),
  MAX(InstructionLineItem.coverPeriodTo)
INTO
  :paymentDate,
  :coverPeriodFrom,
  :coverPeriodTo 
FROM
  FinancialInstruction,
  InstructionLineItem 
WHERE FinancialInstruction.finInstructionID = :finInstructionID 
  AND InstructionLineItem.finInstructionID = FinancialInstruction.finInstructionID
  AND InstructionLineItem.caseID = :caseID