Operation Details
Description: Returns the number of open tasks assigned to a user.
Sterotype: ns
SQL 
SELECT
  COUNT (*)
INTO
  :numberOfRecords 
FROM
  TaskAssignment ta,
  Task t 
WHERE ta.relatedName = :relatedName 
  AND t.taskID = ta.taskID 
  AND t.status = :status