Operation Details
Description: This method returns all manual payments received in relation to a liability.
Sterotype: nsmulti
SQL 
SELECT 
  ili.instructLineItemID, 
  ili.instructionLineItemType, 
  ili.instructLineItemCategory, 
  ili.amount, 
  ili.effectiveDate,
  ili.finInstructionID, 
  ili.caseID, 
  ili.concernRoleID, 
  ili.adjustmentInd,
  ili.statusCode, 
  al.amount, 
  al.allocationDate
INTO
  :creditInstructionLineItemID,
  :creditType,
  :creditCategory,
  :creditAmount,
  :creditEffectiveDate,
  :creditFinInstructionID,
  :creditCaseID,
  :creditConcernRoleID,
  :creditAdjustmentInd,
  :creditStatusCode,
  :allocationAmount,
  :allocationDate 
FROM 
  InstructionLineItem ili, AllocationLine al
WHERE 
  ili.caseID = :caseID
  AND al.instructLineItemID = ili.instructLineItemID
  AND ili.creditDebitType = :creditDebitType
  AND ili.instructLineItemCategory = :iliCategory
  AND ili.instructionLineItemType = :iliType  
  AND ili.statusCode = :statusCode