Database SQL Operation: MilestoneWaiverApprovalCheck.searchMilestoneWaiverAppListByUserName
Description: | Returns a list of milestone waiver approval check details based on the user name. |
Sterotype: | nsmulti |
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.userName = :userName
|