APPS.GMI_WF_ITEM_ACTIVATION dependencies on FND_USER

Line 68: /* get the user name from fnd_user */

64: WHEN DUP_VAL_ON_INDEX THEN
65: RAISE wf_item_exists ;
66: END ;
67:
68: /* get the user name from fnd_user */
69: select
70: user_name
71: into
72: l_name

Line 74: fnd_user

70: user_name
71: into
72: l_name
73: from
74: fnd_user
75: where
76: user_id = p_created_by;
77:
78:

Line 81: /* fnd_user row containing the user's display_name in the */

77:
78:
79: /* the following is a hack to get the display_name */
80: /* it should be replaced by a proper API, and depends upon the */
81: /* fnd_user row containing the user's display_name in the */
82: /* description field */
83: /* BEGIN BUG#2513365 Nayini Vikranth */
84: /* Added the ROWNUM condition to avoid the ON-INSERT error. */
85: select

Line 194: from per_assignments_f a, fnd_user b, fnd_user c, wf_roles wu

190: END IF;
191: IF (l_hierarchy_flag = 'HRMS') THEN
192: select c.user_name,wu.display_name
193: into l_approver_name,l_approver_display_name
194: from per_assignments_f a, fnd_user b, fnd_user c, wf_roles wu
195: where a.person_id=b.employee_id
196: and a.supervisor_id=c.employee_id
197: and b.user_name = l_requestor_name
198: and wu.name = c.user_name