Operation Details |
Description: | To retrieve the name of the deduction associated with the specified deduction financial component. |
Sterotype: | ns |
SQL |
SELECT CaseDeductionItem.deductionName INTO :deductionName FROM CaseDeductionItem, CaseDeductionItemFCLink WHERE CaseDeductionItemFCLink.financialComponentID = :financialCompID AND CaseDeductionItem.caseDeductionItemID = CaseDeductionItemFCLink.caseDeductionItemID |