APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on FND_MENUS_VL

Line 881: l_menu_disp_name FND_MENUS_VL.USER_MENU_NAME%TYPE;

877: ,x_return_status OUT NOCOPY VARCHAR2
878: ,x_msg_data OUT NOCOPY VARCHAR2)
879: IS
880: l_menu_id NUMBER;
881: l_menu_disp_name FND_MENUS_VL.USER_MENU_NAME%TYPE;
882: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
883: --l_object_id NUMBER;
884: l_ss_id NUMBER := EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID;
885: BEGIN

Line 888: FROM FND_MENUS_VL

884: l_ss_id NUMBER := EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID;
885: BEGIN
886: BEGIN
887: SELECT MENU_ID, USER_MENU_NAME INTO l_menu_id, l_menu_disp_name
888: FROM FND_MENUS_VL
889: WHERE MENU_NAME = p_role_name;
890: EXCEPTION WHEN NO_DATA_FOUND THEN
891: l_menu_id := NULL;
892: l_menu_disp_name := '-X-';