| Operation Details |  |
| Description: | Retrieves the count of rosters associated with the provider offering. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(Roster.rosterID) INTO :count FROM Roster, ProviderOffering WHERE Roster.serviceID = :1.providerOfferingID AND Roster.recordStatus = :2.recordStatus |