Operation Details
Description: Searches the Service Authorization Line Item by Service Offering Details like Service ID, Service From Date, Service To Date and Service Authorization ID.
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.serviceAuthorizationID = :serviceAuthorizationID 
  AND ServiceAuthorizationLineItem.fromDate <= :authorizedFrom 
  AND ServiceAuthorizationLineItem.recordStatus <> :recordStatus 
  AND 
  (
    ServiceAuthorizationLineItem.toDate is NULL 
    OR ServiceAuthorizationLineItem.toDate >= :authorizedTo 
  )