APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BIS_TARGET_LEVELS

Line 263: FROM bis_target_levels

259: ) IS
260:
261: CURSOR c_source IS
262: SELECT source
263: FROM bis_target_levels
264: WHERE target_level_id = p_target_level_id;
265:
266: CURSOR c_org_dimension_index IS
267: SELECT x.sequence_no,

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

273: 5, z.dimension5_level_id,
274: 6, z.dimension6_level_id,
275: 7, z.dimension7_level_id,
276: NULL) org_dimension_level_id
277: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
278: WHERE x.dimension_id = y.dimension_id AND
279: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND
280: x.indicator_id = z.indicator_id AND
281: z.target_level_id = p_target_level_id;

Line 454: FROM bis_target_levels

450: e_no_next_period EXCEPTION;
451:
452: CURSOR c_source IS
453: SELECT source
454: FROM bis_target_levels
455: WHERE target_level_id = p_target_level_id;
456:
457: CURSOR c_org_dimension_index IS
458: SELECT x.sequence_no,

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

464: 5, z.dimension5_level_id,
465: 6, z.dimension6_level_id,
466: 7, z.dimension7_level_id,
467: NULL) org_dimension_level_id
468: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
469: WHERE x.dimension_id = y.dimension_id AND
470: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND
471: x.indicator_id = z.indicator_id AND
472: z.target_level_id = p_target_level_id;

Line 675: FROM bis_indicators i, bis_target_levels t

671: ) RETURN VARCHAR2 IS
672:
673: CURSOR c_measure IS
674: SELECT i.short_name
675: FROM bis_indicators i, bis_target_levels t
676: WHERE i.indicator_id = t.indicator_id AND
677: t.target_level_id = p_target_level_id;
678:
679: CURSOR c_dim_level(dimension_index NUMBER) IS

Line 692: FROM bis_target_levels

688: 5, dimension5_level_id,
689: 6, dimension6_level_id,
690: 7, dimension7_level_id,
691: NULL)
692: FROM bis_target_levels
693: WHERE target_level_id = p_target_level_id);
694:
695: CURSOR c_dim_level_value(dimension_index NUMBER) IS
696: SELECT decode(dimension_index,

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

5261: l_OrgSeqNum number;
5262: Begin
5263: begin
5264: SELECT x.sequence_no into l_OrgSeqNum
5265: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
5266: WHERE x.dimension_id = y.dimension_id
5267: AND y.short_name like BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL)
5268: AND x.indicator_id = z.indicator_id
5269: AND z.target_level_id = p_target_level_id;

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

5283: l_TimeSeqNum number;
5284: Begin
5285: begin
5286: SELECT x.sequence_no into l_TimeSeqNum
5287: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
5288: WHERE x.dimension_id = y.dimension_id
5289: AND y.short_name like BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL)
5290: AND x.indicator_id = z.indicator_id
5291: AND z.target_level_id = p_target_level_id ;

Line 5324: FROM BIS_TARGET_LEVELS

5320: dimension7_level_id
5321: INTO l_dimension1_level_id, l_dimension2_level_id, l_dimension3_level_id,
5322: l_dimension4_level_id, l_dimension5_level_id, l_dimension6_level_id,
5323: l_dimension7_level_id
5324: FROM BIS_TARGET_LEVELS
5325: WHERE target_level_id = p_target_level_id;
5326: exception
5327: when others then
5328: l_OrgLevelValueID := null;

Line 7429: ,bis_target_levels z

7425: NULL) time_dimension_level_id
7426: FROM
7427: bis_indicator_dimensions x
7428: ,bis_dimensions y
7429: ,bis_target_levels z
7430: WHERE x.dimension_id = y.dimension_id
7431: AND y.short_name=BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_tarid,NULL)
7432: AND x.indicator_id = z.indicator_id
7433: AND z.target_level_id = p_tarid;