Operation Details |
Description: | This method returns a list of license status history records for a license in descending order. |
Sterotype: | nsmulti |
SQL |
SELECT licenseStatusHistoryID, licenseID, licenseStatus, createdBy, suspensionReason, effectiveDateTime, rejectionReason, comments INTO :licenseStatusHistoryID, :licenseID, :licenseStatus, :createdBy, :suspensionReason, :effectiveDateTime, :rejectionReason, :comments FROM LicenseStatusHistory WHERE LicenseStatusHistory.licenseID = :licenseID ORDER BY LicenseStatusHistory.effectiveDateTime DESC |