DBA Data[Home] [Help]

APPS.OKL_CURE_WF dependencies on FND_USER

Line 155: from fnd_user fuser,wf_roles wfr

151: l_notification_agent varchar2(100);
152:
153: cursor c_get_agent(p_user_id IN NUMBER) is
154: select wfr.name
155: from fnd_user fuser,wf_roles wfr
156: where orig_system = 'PER'
157: and wfr.orig_system_id =fuser.employee_id
158: and fuser.user_id =p_user_id;
159: