Operation Details
Description: Retrieves a list of Issue Approval Requests for an Issue Delivery.
Sterotype: nsmulti
SQL 
SELECT
  IssueApprovalRequest.issueApprovalRequestID,
  ApprovalRequest.requestedByUser,
  ApprovalRequest.requestedDate,
  ApprovalRequest.approvalDecisionByUser,
  ApprovalRequest.approvalDecisionDate,
  ApprovalRequest.status
INTO
  :issueApprovalRequestID,
  :requestedByUser,
  :requestedDate,
  :approvalDecisionByUser,
  :approvalDecisionDate,
  :status 
FROM
  ApprovalRequest,
  IssueApprovalRequest 
WHERE IssueApprovalRequest.caseID = :caseID 
  AND ApprovalRequest.approvalRequestID = IssueApprovalRequest.approvalRequestID 
ORDER BY requestedDate DESC