APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on FND_MENUS_VL

Line 793: l_menu_disp_name FND_MENUS_VL.USER_MENU_NAME%TYPE;

789: ,x_return_status OUT NOCOPY VARCHAR2
790: ,x_msg_data OUT NOCOPY VARCHAR2)
791: IS
792: l_menu_id NUMBER;
793: l_menu_disp_name FND_MENUS_VL.USER_MENU_NAME%TYPE;
794: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
795: l_object_id NUMBER;
796: l_ss_id NUMBER := EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID;
797: BEGIN

Line 800: FROM FND_MENUS_VL

796: l_ss_id NUMBER := EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID;
797: BEGIN
798: BEGIN
799: SELECT MENU_ID, USER_MENU_NAME INTO l_menu_id, l_menu_disp_name
800: FROM FND_MENUS_VL
801: WHERE MENU_NAME = p_role_name;
802: EXCEPTION WHEN NO_DATA_FOUND THEN
803: l_menu_id := NULL;
804: l_menu_disp_name := '-X-';