Operation Details
Description: Reads the resolution status history details.
Sterotype: ns
SQL 
SELECT
  ResolutionStatusHistory.resolutionStatusHistoryID,
  ResolutionStatusHistory.resolutionID,
  ResolutionStatusHistory.resolutionStatus,
  ResolutionStatusHistory.effectiveDate,
  ResolutionConfiguration.resolution
INTO
  :resolutionStatusHistoryID,
  :resolutionID,
  :resolutionStatus,
  :effectiveDate,
  :resolution 
FROM
  ResolutionConfiguration,
  ResolutionStatusHistory 
WHERE ResolutionStatusHistory.resolutionStatusHistoryID = :resolutionStatusHistoryID 
  AND ResolutionStatusHistory.resolutionConfigurationID = ResolutionConfiguration.resolutionConfigurationID