DBA Data[Home] [Help]

APPS.BSC_METADATA_DESC dependencies on V$DATABASE

Line 436: SELECT Name INTO l_database FROM V$DATABASE;

432:
433: BEGIN
434: l_Kpi_Id := p_kpi_id;
435: put_line('**** METADATA DESCRIPTION OBJECTIVE <'||l_Kpi_Id||'> BEGIN HERE ****');
436: SELECT Name INTO l_database FROM V$DATABASE;
437: l_error_msg := ' Objective ID <'||l_Kpi_Id||'> does not exists in '||l_database||' envionment';
438: --PART 1 OF INFORMATION, get general information from BSC_KPIS_VL table
439: put_line('---------------------------------------------------------------------------');
440: put_line('General Objective Information from BSC_KPIS_VL table');