APPS.CTO_UTILITY_PK dependencies on FND_USER

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

6474:
6475:
6476: procedure get_planner_code( p_inventory_item_id in number
6477: , p_organization_id in number
6478: , x_planner_code out NOCOPY fnd_user.user_name%type )
6479: is
6480: begin
6481:
6482: IF PG_DEBUG <> 0 THEN

Line 6494: ,fnd_user u

6490: SELECT u.user_name
6491: INTO x_planner_code
6492: FROM mtl_system_items_vl item
6493: ,mtl_planners p
6494: ,fnd_user u
6495: WHERE item.inventory_item_id = p_inventory_item_id
6496: and item.organization_id = p_organization_id
6497: and p.organization_id = item.organization_id
6498: and p.planner_code = item.planner_code

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

6495: WHERE item.inventory_item_id = p_inventory_item_id
6496: and item.organization_id = p_organization_id
6497: and p.organization_id = item.organization_id
6498: and p.planner_code = item.planner_code
6499: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
6500:
6501:
6502: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || x_planner_code ,2);
6503: