Operation Details
Description: Search for service plan approval request ID and version number by case ID and approval request status.
Sterotype: nsmulti
SQL 
SELECT
  SPApprovalRequest.servicePlanApprovalRequestID,
  SPApprovalRequest.versionNo
INTO
  :servicePlanApprovalRequestID,
  :versionNo 
FROM
  SPApprovalRequest,
  ApprovalRequest 
WHERE SPApprovalRequest.caseID = :caseID 
  AND ApprovalRequest.approvalRequestID = SPApprovalRequest.approvalRequestID 
  AND ApprovalRequest.status = :status