Operation Details
Description: This method list all the special cautions details which are active and end date is null.
Sterotype: nsmulti
SQL 
SELECT
  SpecialCaution.concernRoleID,
  SpecialCaution.specialCautionID,
  SpecialCaution.specialCautionTypeCode,
  SpecialCaution.startDate,
  SpecialCaution.endDate,
  SpecialCaution.comments,
  SpecialCaution.recordStatus
INTO
  :concernRoleID,
  :specialCautionID,
  :typeCode,
  :startDate,
  :endDate,
  :comments,
  :recordStatus 
FROM
  SpecialCaution 
WHERE SpecialCaution.concernRoleID = :concernRoleID 
  AND SpecialCaution.recordStatus = :recordStatus 
  AND SpecialCaution.endDate IS NULL