Operation Details
Description: returns key if an action for this user exists already.
Sterotype: ns
SQL 
SELECT
  UserRecentAction.userRecentActionID
INTO
  :userRecentActionID 
FROM
  UserRecentAction 
WHERE UserRecentAction.userName = :userName 
  AND UserRecentAction.referenceNo = :referenceNo 
  AND UserRecentAction.type = :type 
  AND UserRecentAction.actionType = :actionType