98: -- Cursor used for other deal types
99: cursor cur_notify_users_deal is
100: select fu.USER_NAME, xwf.AMOUNT,xle.EXCEEDED_BY_AMOUNT
101: from XTR_WF_USER_ROLES xwf, 102: XTR_DEALS_V xds, 103: XTR_LIMIT_EXCESS_LOG_V xle,
104: FND_USER fu
105: where xwf.ROLE_NAME = 'XTR_LIMITS_NOTIFICATION'
106: and xds.DEAL_NO = p_deal_no