APPS.BSC_UPDATE_UTIL dependencies on BSC_SYS_DIM_LEVELS_B

Line 2133: FROM bsc_sys_dim_levels_b

2129: h_level_table_name := NULL;
2130:
2131: SELECT level_table_name
2132: INTO h_level_table_name
2133: FROM bsc_sys_dim_levels_b
2134: WHERE level_pk_col = x_level_pk_col;
2135:
2136: RETURN h_level_table_name;
2137:

Line 2156: FROM bsc_sys_dim_levels_b

2152: h_level_view_name := NULL;
2153:
2154: SELECT level_view_name
2155: INTO h_level_view_name
2156: FROM bsc_sys_dim_levels_b
2157: WHERE level_pk_col = x_level_pk_col;
2158:
2159: RETURN h_level_view_name;
2160:

Line 2424: ' FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b d1'||

2420:
2421: /*
2422: c_key_columns t_cursor; -- x_table, h_column_type_p
2423: c_key_columns_sql VARCHAR2(2000) := 'SELECT t.column_name, d.level_view_name, t.source_column, d1.level_view_name'||
2424: ' FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b d1'||
2425: ' WHERE t.table_name = :1 AND t.column_type = :2 AND'||
2426: ' t.column_name = d.level_pk_col AND'||
2427: ' t.source_column = d1.level_pk_col';
2428: */

Line 2431: FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b d1

2427: ' t.source_column = d1.level_pk_col';
2428: */
2429: CURSOR c_key_columns (p_table_name VARCHAR2, p_column_type VARCHAR2) IS
2430: SELECT t.column_name, d.level_view_name, t.source_column, d1.level_view_name
2431: FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b d1
2432: WHERE t.table_name = p_table_name AND t.column_type = p_column_type AND
2433: t.column_name = d.level_pk_col AND
2434: t.source_column = d1.level_pk_col
2435: ORDER BY d.dim_level_id;

Line 2440: h_key_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;

2436:
2437: h_column_type_p VARCHAR2(1);
2438:
2439: h_key_column bsc_db_tables_cols.column_name%TYPE;
2440: h_key_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;
2441: h_source_column bsc_db_tables_cols.source_column%TYPE;
2442: h_source_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;
2443:
2444: BEGIN

Line 2442: h_source_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;

2438:
2439: h_key_column bsc_db_tables_cols.column_name%TYPE;
2440: h_key_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;
2441: h_source_column bsc_db_tables_cols.source_column%TYPE;
2442: h_source_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;
2443:
2444: BEGIN
2445: h_column_type_p := 'P';
2446: