APPS.XTR_WORKFLOW_PKG dependencies on FND_USER

Line 48: l_user_name FND_USER.USER_NAME%type;

44: p_vardate_2 IN DATE)
45: IS
46: l_role_name VARCHAR2(60);
47: l_user_list VARCHAR2(3000);
48: l_user_name FND_USER.USER_NAME%type;
49:
50: -- Cursor used for IG
51: cursor cur_notify_users_ig is
52: select fu.USER_NAME, xwf.AMOUNT,xle.EXCEEDED_BY_AMOUNT

Line 56: FND_USER fu

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
60: and xle.LOG_ID = p_log_id

Line 79: FND_USER fu

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
83: and xle.LOG_ID = p_log_id

Line 104: FND_USER fu

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)
108: and xle.LOG_ID = p_log_id