APPS.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on FND_MENU_ENTRIES

Line 613: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, mtl_system_items out_msib ';

609: -- Bug 13637215 BINDING Start
610: --First query for User privilege
611: l_select_sql :=
612: ' SELECT OUT_MSIB.INVENTORY_ITEM_ID, OUT_MSIB.ORGANIZATION_ID, ' || G_REQUEST_ID ||
613: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, mtl_system_items out_msib ';
614:
615: l_user_name := 'HZ_PARTY:'||TO_CHAR(p_login_person_id);
616: get_orig_key( x_user_name => l_user_name
617: , x_orig_system_id => l_orig_system_id);

Line 651: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

647: ' WHERE item_catalog_group_id = cathier.child_catalog_group_id ';
648:
649: l_dynamic_sql_1 := ' SELECT DISTINCT instance_sets.predicate ' ||
650: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
651: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
652: ' WHERE grants.instance_type = ''SET'' ' ||
653: ' AND grants.start_date <= SYSDATE ' ||
654: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
655: ' AND cmf.function_id = functions.function_id ' ||

Line 2460: FROM fnd_form_functions f, fnd_menu_entries e

2456: ( SELECT roles.menu_id internal_role_id,
2457: roles.menu_name internal_role_name
2458: FROM (
2459: SELECT DISTINCT e.menu_id role_id
2460: FROM fnd_form_functions f, fnd_menu_entries e
2461: WHERE e.function_id = f.function_id
2462: AND f.object_id = G_FND_OBJECT_ID
2463: ) obj_roles,
2464: fnd_menus roles,

Line 2855: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||

2851: || ' AND NOT EXISTS ( ';
2852:
2853: l_select_sql :=
2854: ' SELECT /*+ no_unnest index(grants FND_GRANTS_N5) */ ''X'' ' || --Bug 13637215 add hint
2855: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
2856: ' WHERE grants.instance_pk1_value = to_char(eipi.INVENTORY_ITEM_ID) ' ||
2857: ' AND grants.instance_pk2_value = to_char(eipi.ORGANIZATION_ID) ' ||
2858: ' AND grants.start_date <= sysdate ' ||
2859: ' AND (grants.end_date IS NULL OR grants.end_date >= sysdate) ' ||

Line 2883: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||

2879: ' AND msi.item_catalog_group_id = cathier.child_catalog_group_id ';
2880:
2881: l_dynamic_sql_1 := ' SELECT DISTINCT instance_sets.predicate ' ||
2882: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
2883: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
2884: ' WHERE grants.instance_type = ''SET'' ' ||
2885: ' AND grants.start_date <= SYSDATE ' ||
2886: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
2887: ' AND cmf.function_id = functions.function_id ' ||