APPS.BSC_METADATA_DESC dependencies on BSC_USER_KPI_ACCESS

Line 315: FROM BSC_USER_KPI_ACCESS K,

311: (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR = l_Kpi_Id));
312: -------------------------------------
313: CURSOR c_KPI_Responsibilities IS
314: SELECT K.RESPONSIBILITY_ID, R.RESPONSIBILITY_NAME
315: FROM BSC_USER_KPI_ACCESS K,
316: BSC_RESPONSIBILITY_VL R
317: WHERE K.INDICATOR = l_Kpi_Id
318: AND K.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID (+);
319: -------------------------------------

Line 506: put_line('Objective Responsibilities from BSC_USER_KPI_ACCESS table: ');

502: END IF;
503:
504: l_not_found_msg := ' ERROR. Objective ID <'||l_Kpi_Id||'> is not assigned to any Responsibility';
505: put_line('---------------------------------------------------------------------------');
506: put_line('Objective Responsibilities from BSC_USER_KPI_ACCESS table: ');
507: put_line('---------------------------------------------------------------------------');
508: FOR bsc_cd IN c_KPI_Responsibilities LOOP
509: l_not_found_msg := NULL;
510: put_line('-> RESPONSIBILITY_ID is <'||bsc_cd.RESPONSIBILITY_ID||'>');