APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BIS_LEVELS

Line 2080: l_Time_Dim_Object BIS_LEVELS.SHORT_NAME%TYPE;

2076: l_Dft_periodicity_id NUMBER := NULL;
2077: l_message VARCHAR2(400);
2078: l_flag BOOLEAN;
2079: l_kpi_calendar_id NUMBER;
2080: l_Time_Dim_Object BIS_LEVELS.SHORT_NAME%TYPE;
2081:
2082: CURSOR c_YearPeriodity IS
2083: SELECT a.PERIODICITY_ID
2084: FROM BSC_sys_periodicities a

Line 2325: bis_levels c,

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)
2329: AND c.dimension_id = b.dimension_id

Line 4507: BIS_LEVELS C,

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
4511: AND C.DIMENSION_ID = B.DIMENSION_ID