APPS.BIS_UTILITIES_PVT dependencies on BIS_TARGET_LEVELS

Line 2576: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z

2572: )
2573: IS
2574: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
2575: SELECT x.sequence_no
2576: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
2577: WHERE x.dimension_id = y.dimension_id
2578: AND y.short_name like p_dim
2579: AND x.indicator_id = z.indicator_id
2580: AND ((z.target_level_id = p_targetlevel_id and p_targetlevel_id is not null) OR

Line 2789: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z

2785: )
2786: IS
2787: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
2788: SELECT x.sequence_no
2789: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
2790: WHERE x.dimension_id = y.dimension_id
2791: AND y.short_name like p_dim
2792: AND x.indicator_id = z.indicator_id
2793: AND z.target_level_id = p_targetlevel_id;

Line 2983: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z

2979: )
2980: IS
2981: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
2982: SELECT x.sequence_no
2983: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
2984: WHERE x.dimension_id = y.dimension_id
2985: AND y.short_name like p_dim
2986: AND x.indicator_id = z.indicator_id
2987: AND ((z.target_level_id = p_targetlevel_id and p_targetlevel_id is not null) OR

Line 3083: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z

3079: )
3080: IS
3081: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
3082: SELECT x.sequence_no
3083: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
3084: WHERE x.dimension_id = y.dimension_id
3085: AND y.short_name like p_dim
3086: AND x.indicator_id = z.indicator_id
3087: AND ((z.target_level_id = p_targetlevel_id and p_targetlevel_id is not null) OR

Line 3379: FROM bis_target_levels

3375: IS
3376: ------------------------
3377: CURSOR c_dim_id IS
3378: SELECT source
3379: FROM bis_target_levels
3380: WHERE target_level_id = p_TargetLevelId
3381: ;
3382:
3383: CURSOR c_dim_name IS

Line 3385: FROM bis_target_levels

3381: ;
3382:
3383: CURSOR c_dim_name IS
3384: SELECT source
3385: FROM bis_target_levels
3386: WHERE short_name = p_TargetLevelName
3387: ;
3388: ---------------------------
3389: l_source VARCHAR2(32000);

Line 3430: FROM bis_target_levels

3426:
3427: ------------------------
3428: CURSOR c_dim_id IS
3429: SELECT source
3430: FROM bis_target_levels
3431: WHERE target_level_id = p_TargetLevelId
3432: ;
3433:
3434: CURSOR c_dim_name IS

Line 3436: FROM bis_target_levels

3432: ;
3433:
3434: CURSOR c_dim_name IS
3435: SELECT source
3436: FROM bis_target_levels
3437: WHERE short_name = p_TargetLevelName
3438: ;
3439: ---------------------------
3440:

Line 3497: FROM bis_target_levels

3493: IF p_tgt_lvl_short_name IS NULL THEN
3494:
3495: SELECT short_name
3496: INTO l_tgt_lvl_short_name
3497: FROM bis_target_levels
3498: WHERE target_level_id = p_tgt_lvl_ID;
3499:
3500: ELSE
3501:

Line 3511: bis_target_levels BTL

3507:
3508: SELECT BL.short_name -- 2735844
3509: INTO l_level_short_name
3510: FROM bis_levels BL,
3511: bis_target_levels BTL
3512: WHERE BTL.short_name = l_tgt_lvl_short_name
3513: AND
3514: ( BL.level_id = BTL.dimension1_level_id
3515: OR BL.level_id = BTL.dimension2_level_id

Line 3724: FROM bis_target_levels

3720: IS
3721: ------------------------
3722: CURSOR c_dim_id IS
3723: SELECT source
3724: FROM bis_target_levels
3725: WHERE target_level_id = p_TargetLevelId
3726: ;
3727:
3728: CURSOR c_dim_name IS

Line 3730: FROM bis_target_levels

3726: ;
3727:
3728: CURSOR c_dim_name IS
3729: SELECT source
3730: FROM bis_target_levels
3731: WHERE short_name = p_TargetLevelName
3732: ;
3733: ---------------------------
3734: l_total_name VARCHAR2(2000);