APPS.GMI_WF_ITEM_ACTIVATION dependencies on WF_ROLES

Line 194: from per_assignments_f a, fnd_user b, fnd_user c, wf_roles wu

190: END IF;
191: IF (l_hierarchy_flag = 'HRMS') THEN
192: select c.user_name,wu.display_name
193: into l_approver_name,l_approver_display_name
194: from per_assignments_f a, fnd_user b, fnd_user c, wf_roles wu
195: where a.person_id=b.employee_id
196: and a.supervisor_id=c.employee_id
197: and b.user_name = l_requestor_name
198: and wu.name = c.user_name

Line 203: from ic_item_hierarchy , wf_roles wu

199: group by c.user_name,wu.display_name;
200: ELSIF (l_hierarchy_flag = 'OPM') THEN
201: SELECT supervisor_user_name, wu.display_name
202: into l_approver_name,l_approver_display_name
203: from ic_item_hierarchy , wf_roles wu
204: where creator_user_name = l_requestor_name
205: and rownum = 1
206: and supervisor_user_name=wu.name;
207: END IF;

Line 267: from wf_roles where name =l_approver_name;

263: return;
264: ELSE
265:
266: select display_name into l_approver_display_name
267: from wf_roles where name =l_approver_name;
268:
269:
270: wf_engine.setitemattrtext (itemtype => p_itemtype,
271: itemkey => p_itemkey,