APPS.BSC_UPDATE_LOCK dependencies on BSC_SYS_DIM_LEVELS_B

Line 327: FROM bsc_sys_dim_levels_b

323: h_i NUMBER;
324:
325: CURSOR c_dim_level_id IS
326: SELECT dim_level_id
327: FROM bsc_sys_dim_levels_b
328: WHERE short_name = x_dim_short_name;
329:
330: h_dim_level_id VARCHAR2(50);
331:

Line 765: FROM bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b dp, bsc_sys_dim_level_rels r

761: h_dim_level_id NUMBER;
762:
763: CURSOR c_parent_dims IS
764: SELECT dp.dim_level_id
765: FROM bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b dp, bsc_sys_dim_level_rels r
766: WHERE d.dim_level_id = r.dim_level_id AND
767: r.parent_dim_level_id = dp.dim_level_id AND
768: DECODE(r.relation_type, 2, r.relation_col, d.level_table_name) = x_dim_table;
769:

Line 812: FROM bsc_sys_dim_levels_b

808: END IF;
809: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
810: SELECT dim_level_id
811: INTO h_dim_level_id
812: FROM bsc_sys_dim_levels_b
813: WHERE level_table_name = x_dim_table;
814:
815: h_num_objects := h_num_objects + 1;
816: h_object_keys(h_num_objects) := h_dim_level_id;

Line 878: ' SELECT level_pk_col FROM bsc_sys_dim_levels_b'||

874: ' SELECT table_name FROM bsc_db_tables WHERE table_type = :1)) bt,'||
875: ' bsc_db_tables_cols c'||
876: ' WHERE bt.table_name = c.table_name AND'||
877: ' c.column_type = :2 AND c.column_name IN ('||
878: ' SELECT level_pk_col FROM bsc_sys_dim_levels_b'||
879: ' WHERE '||h_cond_for_base_tables||')';
880: OPEN h_cursor FOR h_sql USING 0, 'P';
881: LOOP
882: FETCH h_cursor INTO h_base_table;