| Operation Details |  |
| Description: | Return reconciliation data for the case ID and date specified. |
| Sterotype: | ns |
| SQL | |
SELECT checkpointID, caseID, fromDate, toDate, creationDate INTO :checkpointID, :caseID, :fromDate, :toDate, :creationDate FROM ReconciliationCheckpoint WHERE caseID = :caseID AND fromDate <= :date AND toDate > :date |