APPS.BSC_UPDATE_CALC dependencies on BSC_SYS_DIM_LEVELS_B

Line 49: ' FROM bsc_sys_dim_levels_b s'||

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'||
50: ' WHERE d.level_pk_col = s.level_pk_col) AND'||
51: ' c.table_name = :4 AND'||
52: ' c.column_name = d.level_pk_col AND'||
53: ' c.column_type = :5'; */

Line 61: FROM bsc_sys_dim_levels_b s

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
62: WHERE d.level_pk_col = s.level_pk_col)
63: AND c.table_name = pTableName
64: AND c.column_name = d.level_pk_col
65: AND c.column_type = pColumnType;

Line 160: FROM bsc_sys_dim_levels_b e, bsc_sys_dim_level_rels r

156: h_account_key VARCHAR2(30);
157:
158: cursor c_type_of_account_key( pLevelPkCol varchar2) is
159: SELECT r.relation_col
160: FROM bsc_sys_dim_levels_b e, bsc_sys_dim_level_rels r
161: WHERE e.dim_level_id = r.dim_level_id AND
162: e.level_pk_col = pLevelPkCol;
163:
164: h_type_of_account_key VARCHAR2(30);

Line 181: FROM bsc_sys_dim_levels_b

177: l_bind_vars_values BSC_UPDATE_UTIL.t_array_of_number;
178:
179: cursor c_dim_table_name(pLevelPkCol varchar2) is
180: SELECT level_view_name
181: FROM bsc_sys_dim_levels_b
182: WHERE level_pk_col = pLevelPkCol;
183:
184: h_acc_key VARCHAR2(30);
185: h_acc_table VARCHAR2(30);