APPS.BSC_UPDATE_UTIL dependencies on BSC_KPI_PERIODICITIES

Line 2284: ' FROM bsc_kpi_periodicities'||

2280:
2281: /*
2282: c_indic t_cursor; -- x_indicator, x_periodicity
2283: c_indic_sql VARCHAR2(2000) := 'SELECT num_of_years, previous_years'||
2284: ' FROM bsc_kpi_periodicities'||
2285: ' WHERE indicator = :1 AND periodicity_id = :2';
2286: */
2287:
2288: BEGIN

Line 2309: FROM bsc_kpi_periodicities

2305: */
2306: BEGIN
2307: SELECT num_of_years, previous_years
2308: INTO x_num_of_years, x_previous_years
2309: FROM bsc_kpi_periodicities
2310: WHERE indicator = x_indicator AND periodicity_id = x_periodicity;
2311: EXCEPTION
2312: WHEN NO_DATA_FOUND THEN
2313: x_num_of_years := 2;

Line 5089: BSC_KPI_PERIODICITIES KP,

5085: 1, K.PERIODICITY_ID||''-''||C.FISCAL_YEAR,
5086: (SELECT
5087: K.PERIODICITY_ID||''-''||L.NAME
5088: FROM
5089: BSC_KPI_PERIODICITIES KP,
5090: BSC_SYS_PERIODS_TL L
5091: WHERE
5092: K.INDICATOR = KP.INDICATOR AND
5093: K.PERIODICITY_ID = KP.PERIODICITY_ID AND

Line 5130: BSC_KPI_PERIODICITIES KP,

5126: 1, ''EDW-''||C.FISCAL_YEAR,
5127: (SELECT
5128: ''EDW-''||L.NAME
5129: FROM
5130: BSC_KPI_PERIODICITIES KP,
5131: BSC_EDW_PERIODS_TL L
5132: WHERE
5133: K.INDICATOR = KP.INDICATOR AND
5134: K.PERIODICITY_ID = KP.PERIODICITY_ID AND