Operation Details |
Description: | Returns organizationUnitResourceID by organization unit and resource id and resource status |
Sterotype: | ns |
SQL |
SELECT organisationUnitResourceID INTO :organisationUnitResourceID FROM OrganisationUnitResource WHERE organisationUnitID = :organisationUnitID AND resourceID = :resourceID AND recordStatus = :recordStatus |