APPS.BSC_UPDATE_CALC dependencies on BSC_DB_TABLES

Line 45: ' FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c'||

41: h_dim_set_id NUMBER;
42:
43: /* c_filters t_cursor;
44: c_filters_sql VARCHAR2(2000) := 'SELECT d.level_pk_col, d.level_view_name'||
45: ' FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c'||
46: ' WHERE d.indicator = :1 AND d.dim_set_id = :2 AND d.status = :3 AND'||
47: ' d.level_view_name <> ('||
48: ' SELECT level_view_name'||
49: ' FROM bsc_sys_dim_levels_b s'||

Line 57: FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c

53: ' c.column_type = :5'; */
54: cursor c_filters(pIndicator number,pDimSetId number , pStatus number,
55: pTableName varchar2,pColumnType varchar2) is
56: SELECT d.level_pk_col, d.level_view_name
57: FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c
58: WHERE d.indicator = pIndicator AND d.dim_set_id = pDimSetId
59: AND d.status = pStatus
60: AND d.level_view_name <> (SELECT level_view_name
61: FROM bsc_sys_dim_levels_b s

Line 1665: FROM bsc_db_tables_cols

1661: h_key VARCHAR2(50);
1662:
1663: cursor c_data_columns(pTableName varchar2,pColumnType varchar2) is
1664: SELECT column_name, source_formula
1665: FROM bsc_db_tables_cols
1666: WHERE table_name = pTableName AND column_type = pColumnType;
1667:
1668: --Fix bug#5057247 fix data type of this variables
1669: h_data_column bsc_db_tables_cols.column_name%TYPE;

Line 1669: h_data_column bsc_db_tables_cols.column_name%TYPE;

1665: FROM bsc_db_tables_cols
1666: WHERE table_name = pTableName AND column_type = pColumnType;
1667:
1668: --Fix bug#5057247 fix data type of this variables
1669: h_data_column bsc_db_tables_cols.column_name%TYPE;
1670: h_expression bsc_db_tables_cols.source_formula%TYPE;
1671:
1672: h_lst_where VARCHAR2(32700);
1673: h_lst_keys VARCHAR2(32700);

Line 1670: h_expression bsc_db_tables_cols.source_formula%TYPE;

1666: WHERE table_name = pTableName AND column_type = pColumnType;
1667:
1668: --Fix bug#5057247 fix data type of this variables
1669: h_data_column bsc_db_tables_cols.column_name%TYPE;
1670: h_expression bsc_db_tables_cols.source_formula%TYPE;
1671:
1672: h_lst_where VARCHAR2(32700);
1673: h_lst_keys VARCHAR2(32700);
1674: h_lst_select VARCHAR2(32700);

Line 2058: FROM bsc_db_tables

2054:
2055: IF x_is_base THEN
2056: SELECT current_period
2057: INTO h_old_current_period
2058: FROM bsc_db_tables
2059: WHERE table_name = x_table_name;
2060:
2061: IF x_current_period > h_old_current_period THEN
2062: -- New current period, then we need to recalculate projection for all

Line 3428: -- I have added the condition on source in bsc_db_tables_cols

3424: h_ret BOOLEAN;
3425:
3426: -- SUPPORT_BSC_BIS_MEASURES: Only BSC measures exists in bsc_db_measure_cols_vl and
3427: -- by design we assumed that BIS measures do not have projection.
3428: -- I have added the condition on source in bsc_db_tables_cols
3429: cursor h_cursor (pTableName varchar2,pProjFlag number,pColCnt number,
3430: pColType varchar2,pProjId number, pProjId2 number, pBSCSource varchar2,
3431: pBSCSource1 varchar2) is
3432: SELECT table_name

Line 3433: FROM bsc_db_tables t

3429: cursor h_cursor (pTableName varchar2,pProjFlag number,pColCnt number,
3430: pColType varchar2,pProjId number, pProjId2 number, pBSCSource varchar2,
3431: pBSCSource1 varchar2) is
3432: SELECT table_name
3433: FROM bsc_db_tables t
3434: WHERE table_name = pTableName AND project_flag = pProjFlag AND
3435: pColCnt <> (SELECT COUNT(tc.column_name)
3436: FROM bsc_db_tables_cols tc, bsc_db_measure_cols_vl m
3437: WHERE tc.table_name = t.table_name AND

Line 3436: FROM bsc_db_tables_cols tc, bsc_db_measure_cols_vl m

3432: SELECT table_name
3433: FROM bsc_db_tables t
3434: WHERE table_name = pTableName AND project_flag = pProjFlag AND
3435: pColCnt <> (SELECT COUNT(tc.column_name)
3436: FROM bsc_db_tables_cols tc, bsc_db_measure_cols_vl m
3437: WHERE tc.table_name = t.table_name AND
3438: tc.column_type = pColType AND
3439: NVL(tc.source, pBSCSource) = pBSCSource1 AND
3440: tc.column_name = m.measure_col (+) AND