DBA Data[Home] [Help]

APPS.BSC_KPI_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 4724: FROM bsc_kpi_dim_levels_b

4720: recinfo c%rowtype;
4721:
4722: CURSOR C_SHARE_DIM_LEVELS IS
4723: SELECT dim_set_id,dim_level_index,level_table_name,level_view_name
4724: FROM bsc_kpi_dim_levels_b
4725: WHERE indicator = l_share_kpi;
4726:
4727: begin
4728: FND_MSG_PUB.Initialize;

Line 4780: UPDATE bsc_kpi_dim_levels_b

4776: before deleting the shared objective
4777: /***********************************************/
4778: FOR cd IN C_SHARE_DIM_LEVELS LOOP
4779:
4780: UPDATE bsc_kpi_dim_levels_b
4781: SET level_view_name = cd.level_view_name
4782: WHERE indicator = l_master_kpi
4783: AND dim_set_id = cd.dim_set_id
4784: AND dim_level_index = cd.dim_level_index