Operation Details
Description: Method to search active Special Caution Details list by concern role ID and date.
Sterotype: nsmulti
SQL 
SELECT DISTINCT
  SpecialCaution.specialCautionTypeCode,
  SpecialCaution.startDate
INTO
  :specialCautionTypeCode,
  :startDate
FROM
  SpecialCaution 
WHERE SpecialCaution.concernRoleID = :concernRoleID 
  AND SpecialCaution.recordStatus = :recordStatus 
  AND SpecialCaution.startDate <= :currentDate
  AND (SpecialCaution.endDate IS NULL OR SpecialCaution.endDate > :currentDate)