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