DBA Data[Home] [Help]

APPS.XTR_WORKFLOW_PKG dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 77: XTR_ROLLOVER_TRANSACTIONS_V xds,

73: -- Cursor used for ONC
74: cursor cur_notify_users_onc is
75: select fu.USER_NAME, xwf.AMOUNT,xle.EXCEEDED_BY_AMOUNT
76: from XTR_WF_USER_ROLES xwf,
77: XTR_ROLLOVER_TRANSACTIONS_V xds,
78: XTR_LIMIT_EXCESS_LOG_V xle,
79: FND_USER fu
80: where xwf.ROLE_NAME = 'XTR_LIMITS_NOTIFICATION'
81: and xds.DEAL_NUMBER = p_deal_no