APPS.FND_REQUEST dependencies on WF_ROLES

Line 2833: from wf_roles

2829: function add_notification (user in varchar2) return boolean is
2830: n_index number;
2831: cursor c1( user_name varchar2) is
2832: select name, orig_system, orig_system_id
2833: from wf_roles
2834: where name = user_name;
2835: begin
2836:
2837: -- Same user may exists in different departments(tables).

Line 2840: -- we are considering only the first row that matched in wf_roles.

2836:
2837: -- Same user may exists in different departments(tables).
2838: -- use cursor because we dont know the given user name will return one row
2839: -- multiple rows.
2840: -- we are considering only the first row that matched in wf_roles.
2841:
2842: n_index := P_NOTIFICATION_COUNT + 1;
2843: open c1( user );
2844: fetch c1 into P_NOTIFICATIONS(n_index).name,