Operation Details
Description: Reads servicePlanApprovalRequestID and submitbaselineID from SPApprovalRequest and versionNo from ApprovalRequest based on the specified caseID and status of a service plan.
Sterotype: ns
SQL 
SELECT
  SPApprovalRequest.servicePlanApprovalRequestID,
  ApprovalRequest.versionNo,
  SPApprovalRequest.submitBaselineID
INTO
  :servicePlanApprovalRequestID,
  :versionNo,
  :submitBaselineID 
FROM
  SPApprovalRequest,
  ApprovalRequest 
WHERE SPApprovalRequest.caseID = :caseID 
  AND ApprovalRequest.approvalRequestID = SPApprovalRequest.approvalRequestID 
  AND ApprovalRequest.status = :status