APPS.BSC_MV_ADAPTER dependencies on BSC_SYS_DIM_LEVELS_B

Line 934: from bsc_sys_dim_level_rels rels ,bsc_sys_dim_levels_b levels

930: ) RETURN boolean
931: IS
932: CURSOR cColumns IS
933: select relation_col
934: from bsc_sys_dim_level_rels rels ,bsc_sys_dim_levels_b levels
935: where levels.level_table_name=p_object
936: and rels.dim_level_id=levels.dim_level_id;
937: begin
938: FOR i IN cColumns LOOP

Line 985: select count(1) into l_dim from bsc_sys_dim_levels_b where level_table_name=p_object;

981: write_to_log_file_n('In create_mv_log_on_table '||p_object);
982: end if;
983: p_snplog_created:=false;
984: l_number_columns := 0;
985: select count(1) into l_dim from bsc_sys_dim_levels_b where level_table_name=p_object;
986: if(l_dim=0) then -- not dimension
987: if BSC_IM_INT_MD.get_column(
988: p_object,
989: p_apps_origin,