Operation Details
Description: Searches related reference by ILI.
Sterotype: nsmulti
SQL 
SELECT
  CaseDecisionObjective.relatedReference,
  CaseDecisionObjective.caseDecisionObjectiveID,
  CaseDecisionObjective.caseDecisionID,
  CaseDecisionObjective.concernRoleID,
  CaseDecisionObjective.objectiveID
INTO
  :relatedReference,
  :caseDecisionObjectiveID,
  :caseDecisionID,
  :concernRoleID,
  :objectiveID 
FROM
  CaseDecisionFinancialComp,
  CaseDecisionObjective 
WHERE CaseDecisionFinancialComp.financialCompID = :financialCompID 
  AND CaseDecisionObjective.caseDecisionObjectiveID = CaseDecisionFinancialComp.caseDecisionObjectiveID