Operation Details
Description: Searches service invoice line item by authorization ID and either of two given statuses.
Sterotype: nsmulti
SQL 
SELECT  

serviceInvoiceLineItemID, 
serviceInvoiceID, 
referenceNo,
externalReferenceNo,
saReferenceNo,
serviceID,
serviceDateFrom,
serviceDateTo,
noOfUnits,
unitAmount,
amountInvoiced,
caseReferenceNo,
caseID,
clientReferenceNo,
clientID,
clientFirstName,
clientLastName,
clientDOB,
providerReferenceNo,
providerID, 
providerName,
payeeReferenceNo,
payeeID,
payeeName,
payeeNameUpper,
status,
serviceAuthorizationLIID,
expProInd,
allowDuplicateSILI,
validityStatus,
versionNo

INTO 

:serviceInvoiceLineItemID, 
:serviceInvoiceID,
:referenceNo,  
:externalReferenceNo, 
:saReferenceNo, 
:serviceID, 
:serviceDateFrom, 
:serviceDateTo, 
:noOfUnits, 
:unitAmount, 
:amountInvoiced, 
:caseReferenceNo, 
:caseID, 
:clientReferenceNo,
:clientID,
:clientFirstName, 
:clientLastName,
:clientDOB, 
:providerReferenceNo, 
:providerID, 
:providerName, 
:payeeReferenceNo, 
:payeeID, 
:payeeName, 
:payeeNameUpper,
:status, 
:serviceAuthorizationLIID, 
:expProInd, 
:allowDuplicateSILI,
:validityStatus,
:versionNo 

FROM ServiceInvoiceLineItem 

WHERE serviceAuthorizationLIID= :serviceAuthorizationLIID 

AND (status = :status1 OR status = :status2)