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