5406: CURSOR cur_actual
5407: IS
5408: SELECT actual_id,
5409: actual_value
5410: FROM bisbv_actuals acts
5411: WHERE acts.target_level_id = p_target_level_id
5412: AND NVL (acts.dimension1_level_value, '1') =
5413: NVL (p_dimension1_level_value, '1')
5414: AND NVL (acts.dimension2_level_value, '1') =
6373: ,DIMENSION4_LEVEL_VALUE
6374: ,DIMENSION5_LEVEL_VALUE
6375: ,DIMENSION6_LEVEL_VALUE
6376: ,DIMENSION7_LEVEL_VALUE
6377: FROM bisbv_actuals acts
6378: WHERE acts.target_level_id = p_target_rec.target_level_id
6379: AND DECODE(p_time_dimension_index,
6380: 1, 'NILL', NVL(acts.dimension1_level_value, 'NILL'))
6381: = DECODE(p_time_dimension_index,