Operation Details
Description: Return all Action plans for a specified link ID a possible link ID value would be a case ID.
Sterotype: nsmulti
SQL 
SELECT
  ActionPlan.actionPlanID,
  ActionPlan.name,
  ActionPlan.startDate,
  ActionPlan.reviewDate,
  ActionPlan.participantsInAgreementInd,
  ActionPlan.recordStatus
INTO
  :actionPlanID,
  :name,
  :startDate,
  :reviewDate,
  :participantsInAgreementInd,
  :recordStatus 
FROM
  ActionPlan,
  ActionPlanLink 
WHERE ActionPlanLink.linkID = :linkID 
  AND ActionPlanLink.actionPlanID = ActionPlan.actionPlanID 
ORDER BY ActionPlan.startDate DESC