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.fromDate <= :serviceDateFrom
AND ServiceAuthorizationLineItem.recordStatus <> :recordStatus
AND
(
ServiceAuthorizationLineItem.toDate is NULL
OR ServiceAuthorizationLineItem.toDate >= :serviceDateTo
)
|