Operation Details |
Description: | Returns a unique record by pageID, userRole, userName and defaultInd. |
Sterotype: | ns |
SQL |
SELECT userPageConfigID, userRoleName, userName, pageID, config, defaultInd, versionNo INTO :userPageConfigID, :userRoleName, :userName, :pageID, :config, :defaultInd, :versionNo FROM UserPageConfig WHERE userName = :userName AND userRoleName = :userRoleName AND pageID = :pageID AND defaultInd = :defaultInd |