Operation Details
Description: Reads the performance measure against units delivered for a service invoice line item and roster line item for the provider. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced.
Sterotype: ns
SQL 
SELECT
  SUM(unitsDelivered)
INTO
  :count 
FROM
  
  ( 
  SELECT
    SUM(ServiceInvoiceLineItem.noOfUnits) AS unitsDelivered 
  FROM
    ServiceInvoiceLineItem 
  WHERE ServiceInvoiceLineItem.providerID = :resourceID 
    AND ServiceInvoiceLineItem.status = :siliStatus 
  
  UNION ALL
    
  SELECT
    SUM(RosterLineItem.totalUnitsDelivered) AS unitsDelivered 
  FROM
    RosterLineItem,
    ProviderRosterLineItem 
  WHERE RosterLineItem.concernRoleID = :resourceID 
    AND RosterLineItem.rosterLineItemID = ProviderRosterLineItem.rosterLineItemID 
    AND ProviderRosterLineItem.status = :prliStatus 
  ) LineItems