APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on FND_USER

Line 45: l_primary_approver_name fnd_user.user_name%type;

41: l_resp_appl_id varchar2(20);
42: l_resp_string varchar2(20);
43: l_display_name varchar2(80);
44: l_asset_location number;
45: l_primary_approver_name fnd_user.user_name%type;
46: l_maintenance_object_id number;
47: l_asset_group_id number;
48: -- added bug 10399281
49: l_old_content_num Number;

Line 72: from bom_eam_dept_approvers beda, fnd_user fu

68: */
69:
70: cursor c_resp_name is
71: select beda.responsibility_id,beda.responsibility_application_id,fu.user_name
72: from bom_eam_dept_approvers beda, fnd_user fu
73: where
74: beda.dept_id = p_work_request_owning_dept_id
75: and beda.organization_id = p_organization_id
76: and fu.user_id(+) = beda.primary_approver_id;

Line 430: FROM fnd_user

426:
427: BEGIN
428: SELECT user_name
429: INTO l_user_name
430: FROM fnd_user
431: WHERE user_id in (select created_by FROM wip_eam_work_requests where work_request_id = p_work_request_id);
432: EXCEPTION
433: When NO_DATA_FOUND then
434: l_user_name := FND_GLOBAL.USER_NAME ;

Line 1064: (select employee_id from fnd_user where user_name=p_user_name);

1060: SELECT nvl(first_name ||' '||last_name,p_user_name)
1061: INTO l_employee_name
1062: FROM PER_PEOPLE_F
1063: WHERE PERSON_ID=
1064: (select employee_id from fnd_user where user_name=p_user_name);
1065: exception
1066: when others then
1067: l_employee_name := p_user_name;
1068: end;