Operation Details
Description: Reads approval request status by service plan approval request key.
Sterotype: ns
SQL 
SELECT
  ApprovalRequest.status
INTO
  :status 
FROM
  SPApprovalRequest,
  ApprovalRequest 
WHERE SPApprovalRequest.servicePlanApprovalRequestID = :servicePlanApprovalRequestID 
  AND ApprovalRequest.approvalRequestID = SPApprovalRequest.approvalRequestID