APPS.GMPMPACT dependencies on HR_EMPLOYEES

Line 290: x_select := x_select || ' hr_employees hem, ';

286: IF G_fplanner IS NOT NULL OR G_tplanner IS NOT NULL THEN
287: x_select := x_select || ' mtl_planners mpl, ';
288: END IF;
289: IF G_fbuyer IS NOT NULL OR G_tbuyer IS NOT NULL THEN
290: x_select := x_select || ' hr_employees hem, ';
291: END IF;
292: IF G_forg IS NOT NULL OR G_torg IS NOT NULL THEN
293: x_select := x_select || ' mtl_parameters mpa, ';
294: END IF;

Line 2009: FROM mtl_system_items msi, hr_employees he

2005: v_buyer_name VARCHAR2(240);
2006: BEGIN
2007:
2008: SELECT he.full_name INTO v_buyer_name
2009: FROM mtl_system_items msi, hr_employees he
2010: WHERE inventory_item_id = p_inventory_item_id
2011: AND organization_id = p_organization_id
2012: AND msi.buyer_id = he.employee_id;
2013: