APPS.BSC_METADATA_DESC dependencies on BSC_RESPONSIBILITY_VL

Line 316: BSC_RESPONSIBILITY_VL R

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: -------------------------------------
320: CURSOR c_KPI_Dim_sets IS

Line 514: put_line('.... ERROR. Objective Responsibility ID <'||bsc_cd.RESPONSIBILITY_ID||'> is invalide. Not found in BSC_RESPONSIBILITY_VL.' );

510: put_line('-> RESPONSIBILITY_ID is <'||bsc_cd.RESPONSIBILITY_ID||'>');
511: IF bsc_cd.RESPONSIBILITY_NAME IS NOT NULL THEN
512: put_line('.... RESPONSIBILITY_NAME <'||bsc_cd.RESPONSIBILITY_NAME||'>');
513: ELSE
514: put_line('.... ERROR. Objective Responsibility ID <'||bsc_cd.RESPONSIBILITY_ID||'> is invalide. Not found in BSC_RESPONSIBILITY_VL.' );
515: END IF;
516: END LOOP;
517: IF (l_not_found_msg IS NOT NULL) THEN
518: put_line(l_not_found_msg);