APPS.CTO_UTILITY_PK dependencies on FND_USER

Line 6454: , x_planner_code out NOCOPY fnd_user.user_name%type )

6450:
6451:
6452: procedure get_planner_code( p_inventory_item_id in number
6453: , p_organization_id in number
6454: , x_planner_code out NOCOPY fnd_user.user_name%type )
6455: is
6456: begin
6457:
6458: IF PG_DEBUG <> 0 THEN

Line 6470: ,fnd_user u

6466: SELECT u.user_name
6467: INTO x_planner_code
6468: FROM mtl_system_items_vl item
6469: ,mtl_planners p
6470: ,fnd_user u
6471: WHERE item.inventory_item_id = p_inventory_item_id
6472: and item.organization_id = p_organization_id
6473: and p.organization_id = item.organization_id
6474: and p.planner_code = item.planner_code

Line 6475: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.

6471: WHERE item.inventory_item_id = p_inventory_item_id
6472: and item.organization_id = p_organization_id
6473: and p.organization_id = item.organization_id
6474: and p.planner_code = item.planner_code
6475: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
6476:
6477:
6478: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || x_planner_code ,2);
6479: