APPS.OKC_WF_K_APPROVE dependencies on WF_USER_ROLES

Line 163: (select 1 from wf_user_roles

159: where l_approver is not NULL
160: union all
161: select 2 num, l_initiator role, '' name from dual
162: where not exists
163: (select 1 from wf_user_roles
164: where user_name=l_initiator
165: and USER_ORIG_SYSTEM IN ('PER','FND_USR')
166: and ROLE_NAME=l_approver
167: )

Line 178: (select 1 from wf_user_roles

174: where l_approver is not NULL
175: union all
176: select 2 num, l_initiator role, '' name from dual
177: where not exists
178: (select 1 from wf_user_roles
179: where user_name=l_initiator
180: and USER_ORIG_SYSTEM IN ('PER','FND_USR')
181: and ROLE_NAME=l_approver
182: )

Line 198: (select distinct user_name from wf_user_roles

194: select role, name from -- here should be your view
195: ------------------------------------------------------
196: (select rownum num, user_name role, '' name
197: from
198: (select distinct user_name from wf_user_roles
199: where role_name in (l_initiator,l_approver)))
200: ------------------------------------------------------
201: where (p_current is NULL
202: or num > (select num from -- same view

Line 206: (select distinct user_name from wf_user_roles

202: or num > (select num from -- same view
203: ------------------------------------------------------
204: (select rownum num, user_name role, '' name
205: from
206: (select distinct user_name from wf_user_roles
207: where role_name in (l_initiator,l_approver)))
208: ------------------------------------------------------
209: where role = p_current)
210: ) order by num;

Line 412: from wf_user_roles r, wf_users u

408: /* the cursor changed because of bug#2316572 -- INCORRECT APPROVER NAME FOR FORWARDED CONTRACT APPROVAL
409: cursor Actual_Performer_csr is
410: select --+ORDERED
411: u.name, u.display_name
412: from wf_user_roles r, wf_users u
413: where r.role_name=l_name
414: and r.USER_ORIG_SYSTEM=u.ORIG_SYSTEM
415: and r.USER_ORIG_SYSTEM_ID=u.ORIG_SYSTEM_ID
416: and

Line 424: -- looks like we don't need select from wf_user_roles (reassignment to user not to role)

420: (l_context like 'email:%' and u.EMAIL_ADDRESS=substr(l_context,7))
421: );
422: */ -- bug#2316572
423: -- the above cursor is changed because of bug#2316572 (discussed with msengupt)
424: -- looks like we don't need select from wf_user_roles (reassignment to user not to role)
425: cursor Actual_Performer_csr is
426: select --+ORDERED
427: u.name, u.display_name
428: from