[Home] [Help]
8076: WHERE indicator = p_indicator;
8077:
8078: CURSOR c_common_dim(p_tab_id NUMBER, p_dim VARCHAR2) IS
8079: SELECT 1
8080: FROM bsc_sys_com_dim_levels
8081: WHERE tab_id = p_tab_id
8082: AND dim_level_id IN ( SELECT dim_level_id
8083: FROM bsc_sys_dim_levels_by_group dim_lvl, bsc_sys_dim_groups_vl dim
8084: WHERE dim.short_name = p_dim