| Operation Details |  |
| Description: | Returns the case id and case reference based on the financial component id. |
| Sterotype: | ns |
| SQL | |
SELECT fincomp.caseID, ch.caseReference INTO :caseID, :caseReference FROM FINANCIALCOMPONENT fincomp LEFT OUTER JOIN CaseHeader ch ON ch.caseID = fincomp.caseID WHERE fincomp.financialCompID = :financialCompID |