Operation Details
Description: This method will provide the waiver request details along with the approval and rejection details
Sterotype: ns
SQL 
SELECT
  MilestoneConfiguration.name,
  MilestoneWaiverApprovalRequest.originalExpStartDate,
  MilestoneWaiverApprovalRequest.requestedExpStartDate,
  MilestoneWaiverApprovalRequest.originalExpEndDate,
  MilestoneWaiverApprovalRequest.requestedExpEndDate,
  MilestoneWaiverApprovalRequest.requestComments,
  MilestoneWaiverApprovalRequest.requestedDate,
  MilestoneWaiverApprovalRequest.approvedExpStartDate,
  MilestoneWaiverApprovalRequest.approvedExpEndDate,
  MilestoneWaiverApprovalRequest.approvalComments,
  ApprovalRequest.requestedByUser,
  ApprovalRequest.status,
  ApprovalRequest.approvalDecisionDate,
  ApprovalRequest.approvalDecisionByUser,
  ApprovalRequest.rejectionReason,
  ApprovalRequest.rejectionComments
INTO
  :name,
  :originalExpStartDate,
  :requestedExpStartDate,
  :originalExpEndDate,
  :requestedExpEndDate,
  :requestComments,
  :requestedDate,
  :approvedExpStartDate,
  :approvedExpEndDate,
  :approvalComments,
  :requestedByUser,
  :status,
  :approvalDecisionDate,
  :approvalDecisionByUser,
  :rejectionReason,
  :rejectionComments 
FROM
  MilestoneDelivery,
  MilestoneConfiguration,
  ApprovalRequest,
  MilestoneWaiverApprovalRequest 
WHERE MilestoneDelivery.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID 
  AND MilestoneDelivery.milestoneDeliveryID = MilestoneWaiverApprovalRequest.milestoneDeliveryID 
  AND MilestoneWaiverApprovalRequest.approvalRequestID = ApprovalRequest.approvalRequestID 
  AND MilestoneWaiverApprovalRequest.waiverApprovalRequestID = :waiverApprovalRequestID