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 |