Operation Details
Description: Method to read Situation records for specified actionPlanID.
Sterotype: nsmulti
SQL 
SELECT
  situationID,
  actionPlanID,
  situationCategory,
  situationRequiringAction,
  expectedEndDate,
  actualEndDate,
  outcome,
  comments,
  recordStatus
INTO
  :situationID,
  :actionPlanID,
  :situationCategory,
  :situationRequiringAction,
  :expectedEndDate,
  :actualEndDate,
  :outcome,
  :comments,
  :recordStatus 
FROM
  Situation
WHERE 
  recordStatus = :recordStatus 
  AND actionPlanID = :actionPlanID