APPS.XTR_WORKFLOW_PKG dependencies on XTR_WF_USER_ROLES

Line 53: from XTR_WF_USER_ROLES xwf,

49:
50: -- Cursor used for IG
51: cursor cur_notify_users_ig is
52: select fu.USER_NAME, xwf.AMOUNT,xle.EXCEEDED_BY_AMOUNT
53: from XTR_WF_USER_ROLES xwf,
54: XTR_INTERGROUP_TRANSFERS_V xds,
55: XTR_LIMIT_EXCESS_LOG_V xle,
56: FND_USER fu
57: where xwf.ROLE_NAME = 'XTR_LIMITS_NOTIFICATION'

Line 76: from XTR_WF_USER_ROLES xwf,

72:
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'

Line 101: from XTR_WF_USER_ROLES xwf,

97:
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'