Database SQL Operation: EvidenceApprovalCheck.readByStatusTypeOrgUnitID
Description: | Returns the maximum percentage for the specified status, type and organization unit identifier. |
Sterotype: | ns |
SELECT
DISTINCT (percentage)
FROM
EvidenceApprovalCheck
WHERE typeCode = :typeCode
AND userName = :userName
AND recordStatus = :recordStatus
AND percentage =
(
SELECT
MAX(percentage)
INTO
:percentage
FROM
EvidenceApprovalCheck,
PositionHolderLink,
Position,
OrganisationUnit,
OrgUnitPositionLink
WHERE PositionHolderLink.userName = :userName
AND Position.positionID = PositionHolderLink.positionID
AND
(
(
OrgUnitPositionLink.organisationUnitID = OrganisationUnit.organisationUnitID
)
AND
(
OrgUnitPositionLink.positionID = Position.positionID
)
)
AND EvidenceApprovalCheck.typeCode = :typeCode
AND EvidenceApprovalCheck.recordStatus = :recordStatus
)
|