DBA Data[Home] [Help]

APPS.BSC_UTILITY dependencies on BSC_KPI_DIM_LEVELS_B

Line 1729: FROM bsc_kpi_dim_levels_b

1725: IF(l_Flag = TRUE)THEN
1726: SELECT COUNT(0) into l_count
1727: FROM (
1728: (SELECT dim_level_index
1729: FROM bsc_kpi_dim_levels_b
1730: WHERE INDICATOR = p_kpi_id
1731: AND dim_set_id = p_dim_set_id )
1732: MINUS
1733: ((SELECT DISTINCT (parent_level_index)

Line 1734: FROM bsc_kpi_dim_levels_b

1730: WHERE INDICATOR = p_kpi_id
1731: AND dim_set_id = p_dim_set_id )
1732: MINUS
1733: ((SELECT DISTINCT (parent_level_index)
1734: FROM bsc_kpi_dim_levels_b
1735: WHERE INDICATOR = p_kpi_id
1736: AND dim_set_id = p_dim_set_id
1737: AND parent_level_index IS NOT NULL)
1738: UNION

Line 1740: FROM bsc_kpi_dim_levels_b

1736: AND dim_set_id = p_dim_set_id
1737: AND parent_level_index IS NOT NULL)
1738: UNION
1739: (SELECT dim_level_index
1740: FROM bsc_kpi_dim_levels_b
1741: WHERE INDICATOR = p_kpi_id
1742: AND dim_set_id = p_dim_set_id
1743: AND parent_level_index IS NOT NULL)));
1744: END IF;