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