APPS.ARP_CMREQ_WF dependencies on FND_USER

Line 462: from fnd_user

458: END IF;
459:
460: select employee_id
461: into p_requestor_id
462: from fnd_user
463: where user_id = l_created_by;
464:
465:
466: IF (p_requestor_id IS NULL) THEN

Line 1072: From fnd_user

1068: l_collector_display_name varchar2(240);
1069: /* Bug 3195343 */
1070: Cursor c1 is
1071: Select user_id
1072: From fnd_user
1073: Where employee_id = l_collector_employee_id;
1074: begin
1075: -- SetOrgContext (p_item_key);
1076:

Line 1290: FROM fnd_user

1286: p_item_key,
1287: 'CURRENCY_CODE');
1288:
1289: SELECT user_id INTO l_employee_id
1290: FROM fnd_user
1291: WHERE user_name = l_approver_name;
1292:
1293: SELECT primary_flag INTO l_primary_flag
1294: FROM ar_approval_user_limits aul

Line 1523: from fnd_user

1519: p_item_key,
1520: 'ROLE');
1521:
1522: select employee_id, user_id into l_employee_id, l_approver_id
1523: from fnd_user
1524: where user_name = l_approver_user_name;
1525:
1526: l_count := 0;
1527:

Line 1612: from fnd_user

1608: p_item_key,
1609: 'APPROVER_ID');
1610: BEGIN
1611: select employee_id into l_employee_id
1612: from fnd_user
1613: where user_id = l_approver_id;
1614: EXCEPTION WHEN NO_DATA_FOUND THEN
1615: p_result := 'COMPLETE:NE';
1616: return;

Line 1637: from fnd_user

1633:
1634:
1635: BEGIN
1636: select user_id into l_approver_id
1637: from fnd_user
1638: where employee_id = l_supervisor_emp_id;
1639: EXCEPTION WHEN NO_DATA_FOUND THEN
1640: p_result := 'COMPLETE:NU';
1641: return;

Line 2028: FROM fnd_user

2024: -- select user_id for a primary approver
2025:
2026: SELECT employee_id
2027: INTO l_employee_id
2028: FROM fnd_user
2029: WHERE user_id = p_user_id;
2030:
2031:
2032: select wu.name, wu.display_name

Line 2034: from wf_users wu, fnd_user fu

2030:
2031:
2032: select wu.name, wu.display_name
2033: into p_user_name, p_display_name
2034: from wf_users wu, fnd_user fu
2035: where wu.orig_system = 'PER'
2036: and wu.orig_system_id = l_employee_id
2037: and wu.orig_system_id = fu.employee_id
2038: and fu.user_id = p_user_id

Line 2070: FROM fnd_user

2066: l_approver_id number;
2067: l_manager_user_id number;
2068: Cursor c1 is
2069: SELECT employee_id
2070: FROM fnd_user
2071: WHERE user_id = l_approver_id;
2072: Cursor c2 is
2073: Select user_id
2074: From fnd_user

Line 2074: From fnd_user

2070: FROM fnd_user
2071: WHERE user_id = l_approver_id;
2072: Cursor c2 is
2073: Select user_id
2074: From fnd_user
2075: Where employee_id = l_manager_id ;
2076: BEGIN
2077: -- SetOrgContext (p_item_key);
2078: --

Line 2209: From fnd_user

2205: /* Bug 3195343 */
2206: l_collector_user_id number;
2207: Cursor c1 is
2208: Select user_id
2209: From fnd_user
2210: Where employee_id = l_collector_employee_id;
2211:
2212: begin
2213: