Operation Details
Description: Searches for all service authorization line items for a particular service offering. The method also ensures that provider details is mentioned in the service authorization line item and provider and service authorization line item conforms to passed status.
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,
  Provider,
  ServiceOffering 
WHERE ServiceOffering.serviceOfferingID = :serviceID 
  AND ServiceAuthorizationLineItem.serviceID = ServiceOffering.serviceOfferingID 
  AND ServiceAuthorizationLineItem.recordStatus = :saliRecordStatus 
  AND Provider.providerConcernRoleID = ServiceAuthorizationLineItem.providerID 
  AND Provider.recordStatus = :providerRecordStatus