APPS.BSC_UPDATE_CALC dependencies on BSC_KPI_DIM_LEVELS_B

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