APPS.BSC_UPGRADES dependencies on BSC_USER_KPI_ACCESS

Line 2188: SELECT * FROM BSC_USER_KPI_ACCESS

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
2189: WHERE RESPONSIBILITY_ID = c_mgr_resp;
2190: BEGIN
2191: SELECT responsibility_id
2192: INTO l_pmd_resp

Line 2236: FROM BSC_USER_KPI_ACCESS

2232: END LOOP;
2233: FOR c_kpi_recs IN c_get_upgrade_kpis(l_mgr_resp) LOOP
2234: SELECT COUNT(1)
2235: INTO l_count
2236: FROM BSC_USER_KPI_ACCESS
2237: WHERE INDICATOR = c_kpi_recs.INDICATOR
2238: AND RESPONSIBILITY_ID = l_pmd_resp;
2239:
2240: SELECT COUNT(1)