APPS.BSC_UPGRADES dependencies on BSC_USER_TAB_ACCESS

Line 2184: SELECT * FROM BSC_USER_TAB_ACCESS

2180: x_return_status VARCHAR2(5000);
2181: x_msg_count NUMBER;
2182: x_msg_data VARCHAR2(5000);
2183: CURSOR c_get_upgrade_tabs (c_mgr_resp NUMBER) IS
2184: SELECT * FROM BSC_USER_TAB_ACCESS
2185: WHERE RESPONSIBILITY_ID = c_mgr_resp;
2186:
2187: CURSOR c_get_upgrade_kpis(c_mgr_resp NUMBER) IS
2188: SELECT * FROM BSC_USER_KPI_ACCESS

Line 2204: FROM BSC_USER_TAB_ACCESS

2200:
2201: FOR c_tab_recs IN c_get_upgrade_tabs(l_mgr_resp) LOOP
2202: SELECT COUNT(1)
2203: INTO l_count
2204: FROM BSC_USER_TAB_ACCESS
2205: WHERE TAB_ID = c_tab_recs.TAB_ID
2206: AND RESPONSIBILITY_ID = l_pmd_resp;
2207:
2208: SELECT COUNT(1)