Operation Details
Description: Returns baseline name, sub-goal name, sub-goal ID, type code of sub-goal, and sensitivity code of sub-goal for a specified baseline identifier and a sub-goal identifier
Sterotype: ns
SQL 
SELECT
  Baseline.name,
  BaselineSubGoal.name,
  BaselineSubGoal.baselineSubGoalID,
  BaselineSubGoal.typeCode,
  BaselineSubGoal.sensitivityCode
INTO
  :baselineName,
  :subgoalName,
  :plannedSubGoalID,
  :typeCode,
  :sensitivityCode 
FROM
  Baseline,
  BaselineSubGoal 
WHERE BaselineSubGoal.baseLineID = Baseline.baseLineID 
  AND BaselineSubGoal.baseLineID = :baseLineID 
  AND BaselineSubGoal.plannedSubGoalID = :plannedSubGoalID