APPS.BIS_DIMENSION_LEVEL_PVT dependencies on BSC_KPI_DIM_LEVELS_B

Line 2414: SELECT COUNT(1) INTO l_kpi_assing_usage FROM bsc_kpi_dim_levels_b kpi,

2410:
2411: FUNCTION IS_ASSIGNED_TO_KPI( p_dim_level_id IN NUMBER) RETURN BOOLEAN IS
2412: l_kpi_assing_usage NUMBER;
2413: BEGIN
2414: SELECT COUNT(1) INTO l_kpi_assing_usage FROM bsc_kpi_dim_levels_b kpi,
2415: bsc_sys_dim_levels_b do , bis_levels lvl
2416: WHERE do.level_table_name = kpi.level_table_name
2417: AND do.short_name = lvl.short_name
2418: AND lvl.level_id = p_dim_level_id;