SELECT
  situationID,
  actionPlanID,
  situationCategory,
  situationRequiringAction,
  expectedEndDate,
  actualEndDate,
  outcome,
  comments,
  recordStatus
INTO
  :situationID,
  :actionPlanID,
  :situationCategory,
  :situationRequiringAction,
  :expectedEndDate,
  :actualEndDate,
  :outcome,
  :comments,
  :recordStatus 
FROM
  Situation
WHERE 
  actionPlanID =  :parentLinkID