APPS.FND_SUBMIT dependencies on WF_ROLES

Line 1835: from wf_roles

1831: /* c number;
1832: begin
1833: select count(*)
1834: into c
1835: from wf_roles
1836: where user = name;
1837:
1838: if (c > 0) then
1839: P_NOTIFICATION_COUNT := P_NOTIFICATION_COUNT + 1;

Line 1851: from wf_roles

1847: return FALSE;
1848: end if;*/
1849: cursor c1( user_name varchar2) is
1850: select name, orig_system, orig_system_id
1851: from wf_roles
1852: where name = user_name;
1853: begin
1854:
1855: -- Same user may exists in different departments(tables).

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

1854:
1855: -- Same user may exists in different departments(tables).
1856: -- use cursor because we dont know the given user name will return one row
1857: -- multiple rows.
1858: -- we are considering only the first row that matched in wf_roles.
1859:
1860: n_index := P_NOTIFICATION_COUNT + 1;
1861: open c1( user );
1862: fetch c1 into P_NOTIFICATIONS(n_index).name,