APPS.XTR_WORKFLOW_PKG dependencies on XTR_LIMIT_EXCESS_LOG_V

Line 55: XTR_LIMIT_EXCESS_LOG_V xle,

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'
58: and xds.DEAL_NUMBER = p_deal_no
59: and xds.TRANSACTION_NUMBER = p_trans_no

Line 78: XTR_LIMIT_EXCESS_LOG_V xle,

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
82: and xds.TRANSACTION_NUMBER = p_trans_no

Line 103: XTR_LIMIT_EXCESS_LOG_V xle,

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
107: and nvl(xds.TRANSACTION_NO,0) = nvl(p_trans_no,0)

Line 251: from XTR_LIMIT_EXCESS_LOG_V xle

247: xle.currency, xle.company_code, xle.limit_party,
248: xle.amount_date amount_date_dsp,
249: xle.limiting_amount limiting_amount_dsp,
250: xle.authorised_by, xle.dealer_code, xle.log_id
251: from XTR_LIMIT_EXCESS_LOG_V xle
252: where xle.log_id = p_log_id
253: order by xle.deal_number, xle.transaction_number;
254:
255: l_deal_no VARCHAR2(50);