APPS.FND_REQUEST dependencies on WF_ROLES

Line 3416: from wf_roles

3412: nls_language in varchar2 ) return boolean is
3413: n_index number;
3414: cursor c1( user_name varchar2) is
3415: select name, orig_system, orig_system_id
3416: from wf_roles
3417: where name = user_name;
3418: begin
3419:
3420: -- Same user may exists in different departments(tables).

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

3419:
3420: -- Same user may exists in different departments(tables).
3421: -- use cursor because we dont know the given user name will return one row
3422: -- multiple rows.
3423: -- we are considering only the first row that matched in wf_roles.
3424:
3425: n_index := P_NOTIFICATION_COUNT + 1;
3426: open c1( user );
3427: fetch c1 into P_NOTIFICATIONS(n_index).name,