Operation Details
Description: Returns a list of milestone waiver approval check details based on the organization unit id.
Sterotype: nsmulti
SQL 
SELECT
  MilestoneWaiverApprovalCheck.milestoneWaiverApprovalCheckID,
  MilestoneConfiguration.name,
  MilestoneWaiverApprovalCheck.percentage,
  MilestoneWaiverApprovalCheck.type,
  MilestoneWaiverApprovalCheck.status
INTO
  :milestoneWaiverAppCheckID,
  :milestoneConfigName,
  :percentage,
  :milestoneWaiverAppCheckType,
  :status 
FROM
  MilestoneWaiverApprovalCheck 
  
  LEFT OUTER JOIN
  
  MilestoneConfiguration 
  ON (MilestoneConfiguration.milestoneConfigurationID = MilestoneWaiverApprovalCheck.milestoneConfigurationID) 
WHERE MilestoneWaiverApprovalCheck.organisationUnitID = :organisationUnitID