DBA Data[Home] [Help]

APPS.BSC_UPGRADES dependencies on FND_RESPONSIBILITY

Line 2193: FROM FND_RESPONSIBILITY

2189: WHERE RESPONSIBILITY_ID = c_mgr_resp;
2190: BEGIN
2191: SELECT responsibility_id
2192: INTO l_pmd_resp
2193: FROM FND_RESPONSIBILITY
2194: WHERE responsibility_key = 'BSC_PMD_USER';
2195:
2196: SELECT responsibility_id
2197: INTO l_mgr_resp

Line 2198: FROM FND_RESPONSIBILITY

2194: WHERE responsibility_key = 'BSC_PMD_USER';
2195:
2196: SELECT responsibility_id
2197: INTO l_mgr_resp
2198: FROM FND_RESPONSIBILITY
2199: WHERE responsibility_key = 'BSC_Manager';
2200:
2201: FOR c_tab_recs IN c_get_upgrade_tabs(l_mgr_resp) LOOP
2202: SELECT COUNT(1)

Line 2377: FROM FND_RESPONSIBILITY_VL

2373: BEGIN
2374: --BSC_Manager
2375: SELECT MENU_ID
2376: INTO l_mgr_menu
2377: FROM FND_RESPONSIBILITY_VL
2378: WHERE RESPONSIBILITY_ID = p_mgr_resp;
2379:
2380: --BSC_PMD_USER/BSC_DESIGNER (called two time from bscup.sql)
2381: --once for BSC_PMD_USER and once for BSC_DESIGNER

Line 2384: FROM FND_RESPONSIBILITY_VL

2380: --BSC_PMD_USER/BSC_DESIGNER (called two time from bscup.sql)
2381: --once for BSC_PMD_USER and once for BSC_DESIGNER
2382: SELECT MENU_ID
2383: INTO l_pmd_menu
2384: FROM FND_RESPONSIBILITY_VL
2385: WHERE RESPONSIBILITY_ID = p_pmd_resp;
2386:
2387:
2388: FOR cd IN c_synch_launchpad LOOP