Operation Details
Description: This method is used to read the Issue Approval Request details
Sterotype: ns
SQL 
SELECT
  ApprovalRequest.requestedByUser,
  ApprovalRequest.approvalDecisionByUser,
  ApprovalRequest.status,
  IssueApprovalRequest.submitComments,
  ApprovalRequest.requestedDate,
  ApprovalRequest.approvalDecisionDate,
  ApprovalRequest.rejectionReason,
  ApprovalRequest.rejectionComments
INTO
  :requestedByUser,
  :approvalDecisionByUser,
  :status,
  :submitComments,
  :requestedDate,
  :approvalDecisionDate,
  :rejectionReason,
  :rejectionComments 
FROM
  ApprovalRequest,
  IssueApprovalRequest 
WHERE IssueApprovalRequest.issueApprovalRequestID = :issueApprovalRequestID 
  AND ApprovalRequest.approvalRequestID = IssueApprovalRequest.approvalRequestID