Database SQL Operation: ServicePlanDelivery.readCaseOwnerByPlanPlanItemID
Description: | Reads the owner of the service plan delivery for which the planned item has been created. |
Sterotype: | ns |
SELECT
CaseHeader.ownerOrgObjectLinkID
INTO
:orgObjectLinkID
FROM
PlannedItem,
PlannedSubGoal,
PlannedGoal,
CaseHeader
WHERE PlannedItem.plannedItemID = :plannedItemID
AND PlannedSubGoal.plannedSubGoalID = PlannedItem.plannedSubGoalID
AND PlannedGoal.plannedGoalID = PlannedSubGoal.plannedGoalID
AND CaseHeader.caseID = PlannedGoal.caseID
|