APPS.OKS_WF_K_APPROVE dependencies on WF_USER_ROLES

Line 227: (select 1 from wf_user_roles

223: where l_approver is not NULL
224: union all
225: select 2 num, l_initiator role, '' name from dual
226: where not exists
227: (select 1 from wf_user_roles
228: where user_name=l_initiator
229: and USER_ORIG_SYSTEM IN ('PER','FND_USR')
230: and ROLE_NAME=l_approver
231: )

Line 242: (select 1 from wf_user_roles

238: where l_approver is not NULL
239: union all
240: select 2 num, l_initiator role, '' name from dual
241: where not exists
242: (select 1 from wf_user_roles
243: where user_name=l_initiator
244: and USER_ORIG_SYSTEM IN ('PER','FND_USR')
245: and ROLE_NAME=l_approver
246: )

Line 552: from wf_user_roles r, wf_users u

548: /* the cursor changed because of bug#2316572 -- INCORRECT APPROVER NAME FOR FORWARDED CONTRACT APPROVAL
549: cursor Actual_Performer_csr is
550: select --+ORDERED
551: u.name, u.display_name
552: from wf_user_roles r, wf_users u
553: where r.role_name=l_name
554: and r.USER_ORIG_SYSTEM=u.ORIG_SYSTEM
555: and r.USER_ORIG_SYSTEM_ID=u.ORIG_SYSTEM_ID
556: and

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

560: (l_context like 'email:%' and u.EMAIL_ADDRESS=substr(l_context,7))
561: );
562: */ -- bug#2316572
563: -- the above cursor is changed because of bug#2316572 (discussed with msengupt)
564: -- looks like we don't need select from wf_user_roles (reassignment to user not to role)
565: /* cursor Actual_Performer_csr is
566: select --+ORDERED
567: u.name, u.display_name
568: from