APPS.BSC_DESIGNER_PVT dependencies on BSC_KPIS_VL

Line 1668: BSC_KPIS_VL

1664: h_periodicity NUMBER;
1665:
1666: CURSOR c_cur_year IS
1667: SELECT FISCAL_YEAR FROM
1668: BSC_KPIS_VL
1669: WHERE INDICATOR= l_indicator;
1670: CURSOR c_periodicity IS
1671: SELECT P.PERIODICITY_ID,P.CURRENT_PERIOD
1672: FROM BSC_KPIS_B B, BSC_KPI_PERIODICITIES P

Line 3336: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT DECODE(share_flag, 2, 3, 5) FROM bsc_kpis_vl');

3332:
3333: BSC_APPS.Init_Bsc_Apps;
3334: Init_Kpi_Metadata_Tables_Array();
3335:
3336: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT DECODE(share_flag, 2, 3, 5) FROM bsc_kpis_vl');
3337: l_sql := l_sql || 'WHERE indicator = :1';
3338: OPEN l_cursor FOR l_sql USING p_Source_Indicator;
3339: FETCH l_cursor INTO l_Copy_Type;
3340: CLOSE l_cursor;