APPS.ARP_CMREQ_WF dependencies on FND_USER

Line 173: FROM fnd_user

169: AND orig_system_id = user_id;
170:
171: cursor c3(user_id1 number) is
172: SELECT employee_id
173: FROM fnd_user
174: WHERE user_id = user_id1;
175:
176: begin
177: -- SetOrgContext (p_item_key);

Line 503: from fnd_user

499: p_requestor_id := l_created_by;
500:
501: /* select employee_id
502: into p_requestor_id
503: from fnd_user
504: where user_id = l_created_by;
505:
506:
507: IF (p_requestor_id IS NULL) THEN

Line 1113: From fnd_user

1109: l_collector_display_name varchar2(240);
1110: /* Bug 3195343 */
1111: Cursor c1 is
1112: Select user_id
1113: From fnd_user
1114: Where employee_id = l_collector_employee_id;
1115: begin
1116: -- SetOrgContext (p_item_key);
1117:

Line 1331: FROM fnd_user

1327: p_item_key,
1328: 'CURRENCY_CODE');
1329:
1330: SELECT user_id INTO l_employee_id
1331: FROM fnd_user
1332: WHERE user_name = l_approver_name;
1333:
1334: SELECT primary_flag INTO l_primary_flag
1335: FROM ar_approval_user_limits aul

Line 1564: from fnd_user

1560: p_item_key,
1561: 'ROLE');
1562:
1563: select employee_id, user_id into l_employee_id, l_approver_id
1564: from fnd_user
1565: where user_name = l_approver_user_name;
1566:
1567: l_count := 0;
1568:

Line 1653: from fnd_user

1649: p_item_key,
1650: 'APPROVER_ID');
1651: BEGIN
1652: select employee_id into l_employee_id
1653: from fnd_user
1654: where user_id = l_approver_id;
1655: EXCEPTION WHEN NO_DATA_FOUND THEN
1656: p_result := 'COMPLETE:NE';
1657: return;

Line 1678: from fnd_user

1674:
1675:
1676: BEGIN
1677: select user_id into l_approver_id
1678: from fnd_user
1679: where employee_id = l_supervisor_emp_id;
1680: EXCEPTION WHEN NO_DATA_FOUND THEN
1681: p_result := 'COMPLETE:NU';
1682: return;

Line 2069: FROM fnd_user

2065: -- select user_id for a primary approver
2066:
2067: SELECT employee_id
2068: INTO l_employee_id
2069: FROM fnd_user
2070: WHERE user_id = p_user_id;
2071:
2072:
2073: select wu.name, wu.display_name

Line 2075: from wf_users wu, fnd_user fu

2071:
2072:
2073: select wu.name, wu.display_name
2074: into p_user_name, p_display_name
2075: from wf_users wu, fnd_user fu
2076: where wu.orig_system = 'PER'
2077: and wu.orig_system_id = l_employee_id
2078: and wu.orig_system_id = fu.employee_id
2079: and fu.user_id = p_user_id

Line 2111: FROM fnd_user

2107: l_approver_id number;
2108: l_manager_user_id number;
2109: Cursor c1 is
2110: SELECT employee_id
2111: FROM fnd_user
2112: WHERE user_id = l_approver_id;
2113: Cursor c2 is
2114: Select user_id
2115: From fnd_user

Line 2115: From fnd_user

2111: FROM fnd_user
2112: WHERE user_id = l_approver_id;
2113: Cursor c2 is
2114: Select user_id
2115: From fnd_user
2116: Where employee_id = l_manager_id ;
2117: BEGIN
2118: -- SetOrgContext (p_item_key);
2119: --

Line 2250: From fnd_user

2246: /* Bug 3195343 */
2247: l_collector_user_id number;
2248: Cursor c1 is
2249: Select user_id
2250: From fnd_user
2251: Where employee_id = l_collector_employee_id;
2252:
2253: begin
2254: