Operation Details
Description: Method to read Situation details list records for specified actionPlanID and not linked with 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

WHERE  Situation.actionPlanID = :actionPlanID 
AND
Situation.situationID NOT IN 
 (SELECT situationID 
    FROM ActionSituationLink 
    WHERE actionID = :actionID AND 
    ActionSituationLink.recordStatus = :recordStatus ) 
AND 
Situation.recordStatus = :recordStatus