APPS.BSC_PMA_APIS_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 7: where dim_level_id in(select dim_level_id from bsc_sys_dim_levels_b where short_name=p_dim_short_name);

3:
4: FUNCTION is_recursive(p_dim_short_name VARCHAR2) return boolean is
5: cursor cParent is
6: select dim_level_id, parent_dim_level_id from bsc_sys_dim_level_rels
7: where dim_level_id in(select dim_level_id from bsc_sys_dim_levels_b where short_name=p_dim_short_name);
8: l_dim_level_id number;
9: l_parent_dim_level_id number;
10: BEGIN
11: open cParent;