Operation Details
Description: Selects all service plan approval requests related to a single service plan
Sterotype: nsmulti
SQL 
SELECT
  SPApprovalRequest.servicePlanApprovalRequestID,
  SPApprovalRequest.caseID,
  SPApprovalRequest.approvalRequestID,
  SPApprovalRequest.submitBaselineID,
  SPApprovalRequest.approvalBaselineID
INTO
  :servicePlanApprovalRequestID,
  :caseID,
  :approvalRequestID,
  :submitBaselineID,
  :approvalBaselineID 
FROM
  SPApprovalRequest,
  ApprovalRequest 
WHERE SPApprovalRequest.caseID = :caseID 
  AND ApprovalRequest.approvalRequestID = SPApprovalRequest.approvalRequestID