Operation Details
Description: Searches the Service Authorization Line Item for the given Service, Case and Client.
Sterotype: nsmulti
SQL 
SELECT
  ServiceAuthorizationLineItem.serviceAuthorizationLIID,
  ServiceAuthorizationLineItem.serviceAuthorizationID,
  ServiceAuthorizationLineItem.dateAdded,
  ServiceAuthorizationLineItem.fromDate,
  ServiceAuthorizationLineItem.toDate,
  ServiceAuthorizationLineItem.unitsAuthorized,
  ServiceAuthorizationLineItem.unitAmount,
  ServiceAuthorizationLineItem.unitAmountFixedInd,
  ServiceAuthorizationLineItem.totalCost,
  ServiceAuthorizationLineItem.maximumUnits,
  ServiceAuthorizationLineItem.maximumUnitsFrequency,
  ServiceAuthorizationLineItem.providerID,
  ServiceAuthorizationLineItem.serviceID,
  ServiceAuthorizationLineItem.recordStatus,
  ServiceAuthorizationLineItem.nomineeID,
  ServiceAuthorizationLineItem.providerType
INTO
  :serviceAuthorizationLIID,
  :serviceAuthorizationID,
  :dateAdded,
  :fromDate,
  :toDate,
  :unitsAuthorized,
  :unitAmount,
  :unitAmountFixedInd,
  :totalCost,
  :maximumUnits,
  :maximumUnitsFrequency,
  :providerID,
  :serviceID,
  :recordStatus,
  :nomineeID,
  :providerType 
FROM
  ServiceAuthorizationLineItem,
  ServiceAuthorization 
WHERE ServiceAuthorizationLineItem.serviceID = :serviceID 
  AND ServiceAuthorization.serviceAuthorizationID = ServiceAuthorizationLineItem.serviceAuthorizationID 
  AND ServiceAuthorization.concernRoleID = :clientID 
  AND ServiceAuthorization.caseID = :caseID 
  AND ServiceAuthorizationLineItem.recordStatus <> :recordStatus