DBA Data[Home] [Help]

APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BISBV_ACTUALS

Line 5410: FROM bisbv_actuals acts

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') =

Line 6377: FROM bisbv_actuals acts

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,