Operation Details
Description: Retrieves a list of approval request details based on the case id.
Sterotype: nsmulti
SQL 
SELECT
  SPApprovalRequest.servicePlanApprovalRequestID,
  ApprovalRequest.requestedDate,
  ApprovalRequest.requestedByUser,
  ApprovalRequest.approvalDecisionDate,
  ApprovalRequest.approvalDecisionByUser,
  ApprovalRequest.status,
  userRequested.fullName,
  userDecision.fullName
INTO
  :servicePlanApprovalRequestID,
  :requestedDate,
  :requestedByUser,
  :approvalDecisionDate,
  :approvalDecisionByUser,
  :status,
  :requestedByUserFullName,
  :approvalDecisionByUserFullName 
FROM
  SPApprovalRequest,
  Users userRequested,
  ApprovalRequest 
  
  LEFT 
  
  JOIN
  
  Users userDecision 
  ON userDecision.userName = ApprovalRequest.approvalDecisionByUser 
WHERE SPApprovalRequest.caseID = :caseID 
  AND ApprovalRequest.approvalRequestID = SPApprovalRequest.approvalRequestID 
  AND userRequested.userName = ApprovalRequest.requestedByUser