Database SQL Operation: LocationAccess.readAdditionalLocationByMaintainInd
Description: | This method is used to check whether the additional location exist for the given location with the maintain permission. |
Sterotype: | ns |
SELECT
locationAccessID,
locationID,
additionalLocationID,
readInd,
maintainInd
INTO
:locationAccessID,
:locationID,
:additionalLocationID,
:readInd,
:maintainInd
FROM
LocationAccess
WHERE locationID = :locationID
AND additionalLocationID = :additionalLocationID
AND maintainInd = :maintainInd
|