Operation Details
Description: This method lists all existing approval checks for a user.
Sterotype: nsmulti
SQL
SELECT
  investigationApprovalCheckID,
  investigationConfigID,
  percentage,
  recordStatus
INTO
  :investigationApprovalCheckID,
  :investigationConfigID,
  :percentage,
  :recordStatus 
FROM
  InvestigationApprovalCheck 
WHERE userName = :userName 
ORDER BY recordStatus