Database SQL Operation: TradingStatus.searchForDuplicateStatus
Description: | This method will search for a duplicate trading status based on the status and the dates of the trading status |
Sterotype: | nsmulti |
SELECT
concernRoleID,
statusCode,
startDate,
endDate,
tradingStatusID
INTO
:concernRoleID,
:statusCode,
:startDate,
:endDate,
:tradingStatusID
FROM
TradingStatus
WHERE tradingStatusID <> :tradingStatusID
AND concernRoleID = :concernRoleID
AND statusCode = :statusCode
AND
(
(
endDate >= :startDate
OR endDate IS NULL
)
AND
(
startDate <= :endDate
OR :endDate IS NULL
)
)
|