Operation Details |
Description: | This method lists all existing approval checks for a particular investigation. |
Sterotype: | nsmulti |
SQL |
SELECT investigationApprovalCheckID, percentage, recordStatus INTO :investigationApprovalCheckID, :percentage, :recordStatus FROM InvestigationApprovalCheck WHERE investigationConfigID = :investigationConfigID AND organisationUnitID is NULL AND userName is NULL ORDER BY recordStatus |