APPS.BSC_BIS_WRAPPER_PVT dependencies on BIS_DIMENSIONS

Line 606: FROM bis_dimensions

602: BEGIN
603:
604: IF p_dimension_id IS NOT NULL THEN
605: SELECT short_name INTO l_short_name
606: FROM bis_dimensions
607: WHERE dimension_id = p_dimension_id;
608: END IF;
609:
610: RETURN l_short_name;

Line 1338: ' FROM bis_levels l, bis_dimensions d'||

1334: RETURN;
1335: END IF;
1336:
1337: l_sql := 'SELECT DISTINCT l.source'||
1338: ' FROM bis_levels l, bis_dimensions d'||
1339: ' WHERE d.dimension_id = l.dimension_id AND d.short_name = :1';
1340:
1341: OPEN cv FOR l_sql USING p_dimension_short_name;
1342: FETCH cv INTO l_source;

Line 1359: ' FROM bis_levels l, bis_dimensions d'||

1355: -- x_total_dimlevel_short_name := 'TOTAL_'||p_dimension_short_name;
1356:
1357: -- The total dimension level starts with TOTAL
1358: l_sql := 'SELECT DISTINCT l.short_name'||
1359: ' FROM bis_levels l, bis_dimensions d'||
1360: ' WHERE d.dimension_id = l.dimension_id AND'||
1361: ' d.short_name = :1 AND l.short_name LIKE ''TOTAL%''';
1362:
1363: OPEN cv FOR l_sql USING p_dimension_short_name;

Line 1442: ' BIS_DIMENSIONS BID'||

1438: l_sql := 'SELECT BID.SHORT_NAME DIMENSION_SHORTNAME, '||
1439: ' BKL.LEVEL_SHORTNAME '||
1440: ' FROM BSC_KPI_DIM_LEVELS_VL BKL,'||
1441: ' BIS_LEVELS BIL,'||
1442: ' BIS_DIMENSIONS BID'||
1443: ' WHERE BKL.INDICATOR = :1 AND'||
1444: ' BKL.DIM_SET_ID = :2 AND'||
1445: ' BKL.LEVEL_SOURCE = ''PMF'' AND'||
1446: ' (BKL.DEFAULT_VALUE = ''C'' OR BKL.DEFAULT_VALUE = ''LD'' ) AND'||

Line 1519: ' BIS_DIMENSIONS BID'||

1515: ' BKL.LEVEL_SHORTNAME, '||
1516: ' DECODE(BKL.DEFAULT_VALUE,''C'', 1, ''LD'', 1, 0) DEFAULT_FLAG '||
1517: ' FROM BSC_KPI_DIM_LEVELS_VL BKL,'||
1518: ' BIS_LEVELS BIL,'||
1519: ' BIS_DIMENSIONS BID'||
1520: ' WHERE BKL.INDICATOR = :1 AND'||
1521: ' BKL.DIM_SET_ID = :2 AND'||
1522: ' BKL.LEVEL_SOURCE = ''PMF'' AND'||
1523: ' BKL.LEVEL_SHORTNAME = BIL.SHORT_NAME AND'||

Line 2487: ' BIS_DIMENSIONS BID'||

2483: l_sql := 'SELECT BID.SHORT_NAME DIMENSION_SHORTNAME, '||
2484: ' BKL.LEVEL_SHORTNAME '||
2485: ' FROM BSC_KPI_DIM_LEVELS_VL BKL,'||
2486: ' BIS_LEVELS BIL,'||
2487: ' BIS_DIMENSIONS BID'||
2488: ' WHERE BKL.INDICATOR = :1 AND'||
2489: ' BKL.DIM_SET_ID = :2 AND'||
2490: ' BKL.LEVEL_SOURCE = ''PMF'' AND'||
2491: ' (BKL.DEFAULT_VALUE = ''C'') AND'||

Line 2515: ' BIS_DIMENSIONS BID'||

2511: l_sql := 'SELECT BID.SHORT_NAME DIMENSION_SHORTNAME, '||
2512: ' BKL.LEVEL_SHORTNAME'||
2513: ' FROM BSC_KPI_DIM_LEVELS_VL BKL,'||
2514: ' BIS_LEVELS BIL,'||
2515: ' BIS_DIMENSIONS BID'||
2516: ' WHERE BKL.INDICATOR = :1 AND'||
2517: ' BKL.DIM_SET_ID = :2 AND'||
2518: ' BKL.LEVEL_SOURCE = ''PMF'' AND'||
2519: ' BKL.LEVEL_SHORTNAME = BIL.SHORT_NAME AND'||