| Operation Details |  |
| Description: | Returns the integratedCaseID and integrated case start date for a specified caseID. |
| Sterotype: | ns |
| SQL | |
SELECT CH1.integratedCaseID, CH2.startDate, CH2.versionNo INTO :caseID, :startDate, :versionNo FROM CaseHeader CH1, CaseHeader CH2 WHERE :caseID = CH1.caseID AND CH2.caseID = CH1.integratedCaseID |