DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_HELPER dependencies on FND_USER

Line 143: from fnd_user

139:
140: CURSOR c_get_user_id(p_user_id IN number)
141: is
142: select employee_id
143: from fnd_user
144: where user_id = p_user_id;
145:
146: --Bug 5370557
147: --Since for a blank timecard there are no detail blocks hence we need to fetch the preparer role from

Line 184: --id associated with the user id from the FND_USER record, and try finding the role using the PER orginal system.

180:
181: if l_name is NULL and l_user_id is not NULL then
182:
183: --If the role name can not be found from the user id, original system is FND, then we should look up the person
184: --id associated with the user id from the FND_USER record, and try finding the role using the PER orginal system.
185: if g_debug then
186: hr_utility.set_location(l_proc, 20);
187: end if;
188:

Line 1052: l_recipient_login fnd_user.user_name%type;

1048: l_tc_stop_date date;
1049: l_tc_start_date date;
1050: l_apr_rej_reason varchar2(2000);
1051: l_fyi_no_detail_body varchar2(4000);
1052: l_recipient_login fnd_user.user_name%type;
1053: l_recipient_id number;
1054: l_supervisor_role wf_local_roles.name%type;
1055: l_tc_id number;
1056: l_tc_ovn number;