APPS.BSC_LAUNCH_PAD_PVT dependencies on FND_MENU_ENTRIES_VL

Line 546: select SUB_MENU_ID from FND_MENU_ENTRIES_VL

542: -- Check if the menu is in the Menu entries - It looks 3 levels down
543: SELECT COUNT(*) VAL
544: INTO h_count
545: FROM (
546: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
547: WHERE MENU_ID = h_top_menu
548: UNION
549: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
550: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL

Line 549: select SUB_MENU_ID from FND_MENU_ENTRIES_VL

545: FROM (
546: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
547: WHERE MENU_ID = h_top_menu
548: UNION
549: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
550: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
551: WHERE MENU_ID = h_top_menu)
552: UNION
553: select SUB_MENU_ID from FND_MENU_ENTRIES_VL

Line 550: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL

546: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
547: WHERE MENU_ID = h_top_menu
548: UNION
549: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
550: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
551: WHERE MENU_ID = h_top_menu)
552: UNION
553: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
554: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL

Line 553: select SUB_MENU_ID from FND_MENU_ENTRIES_VL

549: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
550: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
551: WHERE MENU_ID = h_top_menu)
552: UNION
553: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
554: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
555: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
556: WHERE MENU_ID = h_top_menu))
557: ) MNS

Line 554: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL

550: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
551: WHERE MENU_ID = h_top_menu)
552: UNION
553: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
554: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
555: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
556: WHERE MENU_ID = h_top_menu))
557: ) MNS
558: WHERE MNS.SUB_MENU_ID=X_MENU_ID;

Line 555: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL

551: WHERE MENU_ID = h_top_menu)
552: UNION
553: select SUB_MENU_ID from FND_MENU_ENTRIES_VL
554: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
555: WHERE MENU_ID IN (select SUB_MENU_ID from FND_MENU_ENTRIES_VL
556: WHERE MENU_ID = h_top_menu))
557: ) MNS
558: WHERE MNS.SUB_MENU_ID=X_MENU_ID;
559: END IF;

Line 908: ' FROM fnd_menu_entries_vl@'||x_src_db_link||

904: h_prompt := NULL;
905: h_description := NULL;
906:
907: h_sql := 'SELECT sub_menu_id, grant_flag, prompt, description'||
908: ' FROM fnd_menu_entries_vl@'||x_src_db_link||
909: ' WHERE menu_id = :1 AND function_id = :2';
910: /*' WHERE menu_id = '||h_menu_id_src||' AND function_id = '||h_function_id_src;*/
911:
912:

Line 1081: ' FROM FND_MENU_ENTRIES_VL'||

1077: ' NVL(L.LINK_ID, -1) <> -1 AND'||
1078: ' L.LINK_ID = M.MENU_ID AND'||
1079: ' UPPER(SUBSTR(MENU_NAME,1,3)) = ''BSC'' AND'||
1080: ' NOT (L.LINK_ID IN (SELECT SUB_MENU_ID'||
1081: ' FROM FND_MENU_ENTRIES_VL'||
1082: ' WHERE MENU_ID = :1 AND SUB_MENU_ID IS NOT NULL)) AND'||
1083: /*' WHERE MENU_ID = '||h_top_menu_id||' AND SUB_MENU_ID IS NOT NULL)) AND'||*/
1084: ' LS.LINK_ID IN (SELECT SUB_MENU_ID'||
1085: ' FROM FND_MENU_ENTRIES_VL@'||x_src_db_link||

Line 1085: ' FROM FND_MENU_ENTRIES_VL@'||x_src_db_link||

1081: ' FROM FND_MENU_ENTRIES_VL'||
1082: ' WHERE MENU_ID = :1 AND SUB_MENU_ID IS NOT NULL)) AND'||
1083: /*' WHERE MENU_ID = '||h_top_menu_id||' AND SUB_MENU_ID IS NOT NULL)) AND'||*/
1084: ' LS.LINK_ID IN (SELECT SUB_MENU_ID'||
1085: ' FROM FND_MENU_ENTRIES_VL@'||x_src_db_link||
1086: ' WHERE MENU_ID = :2 AND SUB_MENU_ID IS NOT NULL)';
1087: /* ' WHERE MENU_ID = '||h_top_menu_id_src||' AND SUB_MENU_ID IS NOT NULL)';*/
1088:
1089: