DBA Data[Home] [Help]

APPS.BSC_LAUNCH_PAD_PVT dependencies on FND_RESPONSIBILITY_VL

Line 527: FROM FND_RESPONSIBILITY_VL

523: h_top_menu NUMBER;
524: h_count NUMBER;
525: cursor c_RESPO is
526: SELECT MENU_ID
527: FROM FND_RESPONSIBILITY_VL
528: WHERE RESPONSIBILITY_ID=X_RESPO;
529:
530: BEGIN
531: -- Name

Line 1008: FROM fnd_responsibility_vl

1004: h_cursor INTEGER;
1005:
1006: CURSOR c_top_menu_id IS
1007: SELECT menu_id
1008: FROM fnd_responsibility_vl
1009: WHERE responsibility_id = x_trg_resp;
1010:
1011: h_top_menu_id NUMBER;
1012: h_top_menu_id_src NUMBER;

Line 1031: ' FROM FND_RESPONSIBILITY_VL@'||x_src_db_link||

1027: h_user_id := BSC_APPS.fnd_global_user_id;
1028:
1029: -- Get the top menu id of the source responsibility
1030: h_sql := 'SELECT MENU_ID'||
1031: ' FROM FND_RESPONSIBILITY_VL@'||x_src_db_link||
1032: /*' WHERE RESPONSIBILITY_ID = '||x_src_resp;*/
1033: ' WHERE RESPONSIBILITY_ID = :1';
1034:
1035: h_cursor := DBMS_SQL.OPEN_CURSOR;