Operation Details |
Description: | Get finding details list for specified allegation id. |
Sterotype: | nsmulti |
SQL |
SELECT findingID, allegationID, finding, overrideReason, effectiveDate, createdTimeStamp, comments INTO :findingID, :allegationID, :finding, :overrideReason, :effectiveDate, :createdTimeStamp, :comments FROM Finding WHERE allegationID = :allegationID ORDER BY createdTimeStamp DESC |