Operation Details
Description: Counts organization unit resource records by organization unit and resource id and resource status..
Sterotype: ns
SQL
SELECT
  COUNT(organisationUnitResourceID)
INTO
  :organisationUnitResourceCount 
FROM
  OrganisationUnitResource 
WHERE organisationUnitID = :organisationUnitID 
  AND resourceID = :resourceID 
  AND recordStatus = :recordStatus