DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on HR_EMPLOYEES

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

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

Line 2071: FROM mtl_system_items msi, hr_employees he

2067: v_buyer_name VARCHAR2(240);
2068: BEGIN
2069:
2070: SELECT he.full_name INTO v_buyer_name
2071: FROM mtl_system_items msi, hr_employees he
2072: WHERE inventory_item_id = p_inventory_item_id
2073: AND organization_id = p_organization_id
2074: AND msi.buyer_id = he.employee_id;
2075: