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