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