APPS.FND_SUBMIT dependencies on WF_ROLES

Line 1759: from wf_roles

1755: /* c number;
1756: begin
1757: select count(*)
1758: into c
1759: from wf_roles
1760: where user = name;
1761:
1762: if (c > 0) then
1763: P_NOTIFICATION_COUNT := P_NOTIFICATION_COUNT + 1;

Line 1775: from wf_roles

1771: return FALSE;
1772: end if;*/
1773: cursor c1( user_name varchar2) is
1774: select name, orig_system, orig_system_id
1775: from wf_roles
1776: where name = user_name;
1777: begin
1778:
1779: -- Same user may exists in different departments(tables).

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

1778:
1779: -- Same user may exists in different departments(tables).
1780: -- use cursor because we dont know the given user name will return one row
1781: -- multiple rows.
1782: -- we are considering only the first row that matched in wf_roles.
1783:
1784: n_index := P_NOTIFICATION_COUNT + 1;
1785: open c1( user );
1786: fetch c1 into P_NOTIFICATIONS(n_index).name,