APPS.GMI_WF_ITEM_ACTIVATION dependencies on IC_ITEM_HIERARCHY

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;