Operation Details
Description: Searches for the trading status record based on the concern role ID for a particular date
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.statusCode = :statusCode 
  AND TradingStatus.startDate <= :date 
  AND 
  (
    TradingStatus.endDate > :date 
    OR TradingStatus.endDate IS NULL 
  )