APPS.BSC_BIS_CUSTOM_KPI_UTIL_PUB dependencies on BSC_DB_MEASURE_COLS_VL

Line 233: sql_query := 'SELECT count(1) FROM BSC_SYS_MEASURES a,BSC_DB_MEASURE_COLS_VL b '

229: IF(Flag_Cur%ISOPEN) THEN
230: CLOSE Flag_Cur;
231: END IF;
232:
233: sql_query := 'SELECT count(1) FROM BSC_SYS_MEASURES a,BSC_DB_MEASURE_COLS_VL b '
234: ||' , BSC_DB_MEASURE_GROUPS_VL c '
235: ||' WHERE a.measure_col = b.measure_col '
236: ||' AND a.measure_id = :p_measure_id'
237: ||' AND b.measure_group_id = c.measure_group_id '

Line 309: SELECT measure_group_id FROM BSC_DB_MEASURE_COLS_VL

305: FUNCTION is_KPI_EndToEnd_MeasureCol(p_Measure_Col VARCHAR2)
306: RETURN VARCHAR2
307: IS
308: CURSOR c_MeasureGrp IS
309: SELECT measure_group_id FROM BSC_DB_MEASURE_COLS_VL
310: WHERE measure_col = p_Measure_Col;
311:
312: l_Measure_Group_Id BSC_DB_MEASURE_COLS_VL.MEASURE_GROUP_ID%TYPE;
313:

Line 312: l_Measure_Group_Id BSC_DB_MEASURE_COLS_VL.MEASURE_GROUP_ID%TYPE;

308: CURSOR c_MeasureGrp IS
309: SELECT measure_group_id FROM BSC_DB_MEASURE_COLS_VL
310: WHERE measure_col = p_Measure_Col;
311:
312: l_Measure_Group_Id BSC_DB_MEASURE_COLS_VL.MEASURE_GROUP_ID%TYPE;
313:
314: BEGIN
315: IF(c_MeasureGrp%ISOPEN) THEN
316: CLOSE c_MeasureGrp;