Operation Details
Description: Reads approval request ID, approval request version number, rejection reason, rejection comment and case ID.
Sterotype: ns
SQL 
SELECT
  ApprovalRequest.approvalRequestID,
  ApprovalRequest.versionNo,
  ApprovalRequest.rejectionReason,
  ApprovalRequest.rejectionComments,
  SPApprovalRequest.caseID
INTO
  :approvalRequestID,
  :versionNo,
  :rejectionReason,
  :rejectionComments,
  :caseID 
FROM
  SPApprovalRequest,
  ApprovalRequest 
WHERE SPApprovalRequest.servicePlanApprovalRequestID = :servicePlanApprovalRequestID 
  AND ApprovalRequest.approvalRequestID = SPApprovalRequest.approvalRequestID