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