Operation Details
Description: Counts non-closed and non-completed tasks based on relatedID and assigneeType.
Sterotype: ns
SQL 
SELECT
  count(*)
INTO
  :numberOfRecords 
FROM
  TaskAssignment ta,
  Task t 
WHERE 
  (
    :searchByRelatedIDInd = '0' 
    OR ta.relatedID = :relatedID 
  ) 
  AND ta.assigneeType = :assigneeType
  AND ta.taskID = t.taskID
  AND t.status NOT IN ( :completedStatus, :closedStatus)