APPS.GMI_WF_ITEM_ACTIVATION dependencies on PER_ASSIGNMENTS_F

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