APPS.FND_USER_RESP_GROUPS_API dependencies on WF_ALL_USER_ROLES

Line 201: from wf_all_user_roles

197: if(direct_flag = 'E') then
198: begin
199: select null
200: into dummy
201: from wf_all_user_roles
202: where user_name = username
203: and role_name = rolename
204: and rownum = 1;
205: result := TRUE;

Line 217: from wf_all_user_roles

213: elsif (direct_flag = 'D') then
214: begin
215: select null
216: into dummy
217: from wf_all_user_roles
218: where user_name = username
219: and role_name = rolename
220: and assignment_type in ('D', 'B')
221: and rownum = 1;

Line 234: from wf_all_user_roles

230: elsif (direct_flag = 'I') then
231: begin
232: select null
233: into dummy
234: from wf_all_user_roles
235: where user_name = username
236: and role_name = rolename
237: and assignment_type in ('I', 'B')
238: and rownum = 1;

Line 737: -- from wf_all_user_roles

733: -- select created_by, creation_date, last_updated_by,
734: -- last_update_date, last_update_login
735: -- into l_created_by, l_creation_date, l_last_updated_by,
736: -- l_last_update_date, l_last_update_login
737: -- from wf_all_user_roles
738: -- where user_name = Update_Assignment.username
739: -- and role_orig_system_id = Update_Assignment.responsibility_id
740: -- and role_name = Update_Assignment.rolename
741: -- and role_orig_system = 'FND_RESP';

Line 1535: from wf_all_user_roles waur

1531:
1532: begin
1533: select role_name
1534: into dummy
1535: from wf_all_user_roles waur
1536: where waur.role_name = rolename
1537: and waur.user_name = rowrec.user_name
1538: and ( (waur.start_date = rowrec.start_date)
1539: OR((waur.start_date is NULL) AND (rowrec.start_date is NULL)))