Database SQL Operation: InstructionLineItemRelation.searchForRelatedByFinInstructionID
Description: | Returns a list of the financial instructions that relate to the payment financial instruction ID given. |
Sterotype: | nsmulti |
SELECT
DISTINCT FinancialInstruction.finInstructionID
INTO
:finInstructionID
FROM
InstructionLineItem,
FinancialInstruction
WHERE InstructionLineItem.instructLineItemID IN
(
SELECT
InstructionLineItemRelation.relatedLineItemID
FROM
InstructionLineItemRelation
WHERE InstructionLineItemRelation.instructLineItemID IN
(
SELECT
InstructionLineItem.instructLineItemID
FROM
InstructionLineItem
WHERE InstructionLineItem.finInstructionID = :financialInstructionID
)
)
AND InstructionLineItem.finInstructionID = FinancialInstruction.finInstructionID
|