APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on FND_USER

Line 15: l_app_resource_id FND_USER.EMPLOYEE_ID%TYPE;

11:
12: l_item_key WF_NOTIFICATIONS.ITEM_KEY%TYPE;
13: l_item_type WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
14: l_tc_owner_resource_id varchar2(30);
15: l_app_resource_id FND_USER.EMPLOYEE_ID%TYPE;
16:
17:
18: cursor cur_get_tcapprover_and_ItemKey(l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE)
19: is

Line 22: fnd_user fuser

18: cursor cur_get_tcapprover_and_ItemKey(l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE)
19: is
20: select fuser.employee_id,wf.message_type,wf.item_key
21: from wf_notifications wf,
22: fnd_user fuser
23: where wf.notification_id = l_notification_id
24: and fuser.user_name = wf.RECIPIENT_ROLE;
25:
26: begin

Line 405: l_recipient_login fnd_user.user_name%type;

401: l_tc_start_date date;
402: l_effective_start_date date;
403: l_effective_end_date date;
404: l_fyi_subject varchar2(1000);
405: l_recipient_login fnd_user.user_name%type;
406: l_recipient_id number;
407: l_resend_counter number;
408: l_proc constant varchar2(61) := g_pkg ||'reset_for_next_timeout';
409: BEGIN