APPS.BSC_LAUNCH_PAD_PVT dependencies on FND_MENUS_VL

Line 150: FROM FND_MENUS_VL

146: BEGIN
147: -- Name
148: SELECT count(*)
149: INTO h_count
150: FROM FND_MENUS_VL
151: WHERE MENU_ID <> X_MENU_ID
152: AND (MENU_NAME = X_MENU_NAME);
153: IF h_count > 0 THEN
154: h_val := 'N';

Line 160: FROM FND_MENUS_VL

156: END IF;
157: -- User Name
158: SELECT count(*)
159: INTO h_count
160: FROM FND_MENUS_VL
161: WHERE MENU_ID <> X_MENU_ID
162: AND (upper(USER_MENU_NAME) = X_USER_MENU_NAME);
163: IF h_count > 0 THEN
164: h_val := 'U';

Line 611: FROM fnd_menus_vl

607: WHERE menu_name = h_menu_name;
608:
609: CURSOR c_menu_id_u IS
610: SELECT menu_id
611: FROM fnd_menus_vl
612: WHERE user_menu_name = h_user_menu_name;
613:
614: h_menu_id NUMBER;
615: h_row_id VARCHAR2(30);

Line 664: ' FROM BSC_TAB_VIEW_LABELS_B T, FND_MENUS_VL@'||x_src_db_link||' M'||

660: h_user_id := BSC_APPS.fnd_global_user_id;
661:
662: -- Migrate menus with functions
663: h_sql := 'SELECT DISTINCT M.MENU_NAME, M.USER_MENU_NAME, T.LINK_ID'||
664: ' FROM BSC_TAB_VIEW_LABELS_B T, FND_MENUS_VL@'||x_src_db_link||' M'||
665: ' WHERE T.LABEL_TYPE = 2 AND NVL(T.LINK_ID, -1) <> -1 AND T.LINK_ID = M.MENU_ID';
666:
667: h_cursor := DBMS_SQL.OPEN_CURSOR;
668: DBMS_SQL.PARSE(h_cursor, h_sql, DBMS_SQL.NATIVE);

Line 712: ' FROM fnd_menus_vl@'||x_src_db_link||

708: h_menu_type := NULL;
709: h_description := NULL;
710:
711: h_sql := 'SELECT type, description'||
712: ' FROM fnd_menus_vl@'||x_src_db_link||
713: ' WHERE menu_name =:1';
714: /* ' WHERE menu_name = '''||h_menu_name||'''';*/
715:
716:

Line 966: FROM fnd_menus_vl t, fnd_menus_vl@'||x_src_db_link||' s

962: FROM fnd_menus t, fnd_menus@'||x_src_db_link||' s
963: WHERE t.menu_name = s.menu_name AND
964: l.link_id = s.menu_id),
965: NVL((SELECT t.menu_id
966: FROM fnd_menus_vl t, fnd_menus_vl@'||x_src_db_link||' s
967: WHERE t.user_menu_name = s.user_menu_name AND
968: l.link_id = s.menu_id),
969: -1))
970: WHERE label_type = 2';

Line 1071: ' FND_MENUS_VL M'||

1067: ' M.DESCRIPTION'||
1068: ' FROM'||
1069: ' BSC_TAB_VIEW_LABELS_B L,'||
1070: ' BSC_TAB_VIEW_LABELS_B@'||x_src_db_link||' LS,'||
1071: ' FND_MENUS_VL M'||
1072: ' WHERE'||
1073: ' L.TAB_ID = LS.TAB_ID AND'||
1074: ' L.TAB_VIEW_ID = LS.TAB_VIEW_ID AND'||
1075: ' L.LABEL_ID = LS.LABEL_ID AND'||