DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BIS_DIMENSIONS

Line 1170: FROM bis_dimensions a

1166: ORDER BY a.display_sequence;
1167:
1168: CURSOR c_DimId IS
1169: SELECT a.dimension_id
1170: FROM bis_dimensions a
1171: WHERE UPPER(a.short_name) = UPPER(l_dimension_grp(l_counter));
1172:
1173: BEGIN
1174:

Line 2324: bis_dimensions b,

2320: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_GET_GROUP_ID');
2321: SELECT d.total_flag, d.comparison_flag, d.where_clause
2322: INTO l_total_flag, l_comparison_flag, l_where_clause
2323: FROM bsc_sys_dim_groups_tl a,
2324: bis_dimensions b,
2325: bis_levels c,
2326: bsc_sys_dim_levels_by_group d,
2327: bsc_sys_dim_levels_b e
2328: WHERE c.short_name = p_non_time_dimension_objects(l_index)

Line 4506: BIS_DIMENSIONS B,

4502: SELECT D.TOTAL_FLAG,
4503: D.COMPARISON_FLAG,
4504: D.WHERE_CLAUSE
4505: FROM BSC_SYS_DIM_GROUPS_TL A,
4506: BIS_DIMENSIONS B,
4507: BIS_LEVELS C,
4508: BSC_SYS_DIM_LEVELS_BY_GROUP D,
4509: BSC_SYS_DIM_LEVELS_B E
4510: WHERE C.SHORT_NAME = l_Dim_Obj_Short_Name

Line 7738: FROM BIS_DIMENSIONS A

7734: l_Dim_Id_Cnt NUMBER;
7735:
7736: CURSOR c_DimId IS
7737: SELECT a.DIMENSION_ID
7738: FROM BIS_DIMENSIONS A
7739: WHERE UPPER(a.SHORT_NAME) = UPPER(l_Dimension_Grp(l_Counter));
7740:
7741:
7742: