APPS.JTF_RS_RESOURCE_WF_PUB dependencies on FND_USER

Line 99: l_approver fnd_user.user_name%type;

95: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
96:
97: l_source_number jtf_rs_resource_extns.source_number%type;
98:
99: l_approver fnd_user.user_name%type;
100: l_requestor fnd_user.user_name%type;
101:
102: l_errname varchar2(60);
103: l_errmsg varchar2(2000);

Line 100: l_requestor fnd_user.user_name%type;

96:
97: l_source_number jtf_rs_resource_extns.source_number%type;
98:
99: l_approver fnd_user.user_name%type;
100: l_requestor fnd_user.user_name%type;
101:
102: l_errname varchar2(60);
103: l_errmsg varchar2(2000);
104: l_errstack varchar2(4000);

Line 111: FROM fnd_user

107: l_error_flag varchar2(1) := 'N';
108:
109: CURSOR c_user (l_employee_id number) IS
110: SELECT user_name
111: FROM fnd_user
112: WHERE employee_id = l_employee_id
113: ORDER by creation_date desc;
114:
115: CURSOR c_resource (l_resource_id number) IS