APPS.BSC_KPI_PUB dependencies on BSC_KPI_DIM_GROUPS

Line 576: bsc_kpi_dim_groups kpi_dim,

572: SELECT
573: sys_dim.short_name
574: FROM
575: bsc_kpis_b kpi,
576: bsc_kpi_dim_groups kpi_dim,
577: bsc_sys_dim_groups_vl sys_dim
578: WHERE
579: kpi.indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id AND
580: kpi.short_name IS NULL AND

Line 1478: ' from BSC_KPI_DIM_GROUPS ' ||

1474: -- Before we delete the Dimension set we need to delete the Dimension Groups associated
1475: -- with the dimension set. In order to get all groups in the Dim. set we need to use
1476: -- a cursor to query the database.
1477: l_sql2 := 'select distinct(dim_group_id) ' ||
1478: ' from BSC_KPI_DIM_GROUPS ' ||
1479: ' where indicator = :1' ||
1480: ' and dim_set_id = :2';
1481:
1482: open dc_value2 for l_sql2 using l_Bsc_Dim_Set_Rec.Bsc_Kpi_Id, l_Bsc_Dim_Set_Rec.Bsc_Dim_Set_Id;