Operation Details
Description: This method returns the trading status record with the latest end date for the given concern role id and status code.
Sterotype: ns
SQL 
SELECT
  TradingStatus.concernRoleID,
  TradingStatus.startDate,
  TradingStatus.endDate,
  TradingStatus.statusCode,
  TradingStatus.tradingStatusCode,
  TradingStatus.tradingStatusID,
  TradingStatus.versionNo
INTO
  :concernRoleID,
  :startDate,
  :endDate,
  :statusCode,
  :tradingStatusCode,
  :tradingStatusID,
  :versionNo 
FROM
  TradingStatus 
WHERE TradingStatus.concernRoleID = :concernRoleID 
  AND TradingStatus.tradingStatusCode = :tradingStatusCode 
  AND TradingStatus.endDate = 
  ( 
  SELECT
    MAX(endDate) 
  FROM
    TradingStatus 
  WHERE concernRoleID = :concernRoleID 
  )