APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on FND_USER

Line 46: l_primary_approver_name fnd_user.user_name%type;

42: l_resp_appl_id varchar2(20);
43: l_resp_string varchar2(20);
44: l_display_name varchar2(80);
45: l_asset_location number;
46: l_primary_approver_name fnd_user.user_name%type;
47: l_maintenance_object_id number;
48: l_asset_group_id number;
49: /* If multiple responsibility to dept , would pick up the first , but
50: this scenario should not exist as per design */

Line 68: from bom_eam_dept_approvers beda, fnd_user fu

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

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

989: SELECT nvl(first_name ||' '||last_name,p_user_name)
990: INTO l_employee_name
991: FROM PER_PEOPLE_F
992: WHERE PERSON_ID=
993: (select employee_id from fnd_user where user_name=p_user_name);
994: exception
995: when others then
996: l_employee_name := p_user_name;
997: end;