APPS.BSC_UPDATE_SUM dependencies on BSC_KPI_DATA_TABLES

Line 561: FROM bsc_kpi_data_tables

557: h_error_refresh VARCHAR2(2000);
558:
559: CURSOR c_pt_name (p_sum_table VARCHAR2) IS
560: SELECT DISTINCT projection_data
561: FROM bsc_kpi_data_tables
562: WHERE table_name = p_sum_table;
563:
564: h_pt_name VARCHAR2(30);
565: h_process_pt BOOLEAN;

Line 572: FROM bsc_kpi_data_tables kt, bsc_db_tables t

568: h_num_origin_pts NUMBER;
569:
570: CURSOR c_other_tables (p_pt_name VARCHAR2, p_table_name VARCHAR2) IS
571: SELECT DISTINCT kt.table_name, t.project_flag
572: FROM bsc_kpi_data_tables kt, bsc_db_tables t
573: WHERE kt.projection_data = p_pt_name AND
574: kt.table_name <> p_table_name AND
575: kt.table_name = t.table_name;
576:

Line 600: FROM bsc_kpi_data_tables kt, bsc_sys_periodicities p, bsc_db_tables t

596: h_num_pt_periodicities NUMBER;
597:
598: CURSOR c_pt_periodicities (p_pt_name VARCHAR2) IS
599: SELECT DISTINCT p.periodicity_id, p.yearly_flag, t.current_period
600: FROM bsc_kpi_data_tables kt, bsc_sys_periodicities p, bsc_db_tables t
601: WHERE kt.projection_data = p_pt_name AND
602: kt.periodicity_id = p.periodicity_id AND
603: kt.table_name = t.table_name;
604:

Line 2311: ' FROM bsc_kpi_data_tables'||

2307: BEGIN
2308: h_data_source_mv := 'MV';
2309:
2310: h_sql := 'SELECT DISTINCT mv_name'||
2311: ' FROM bsc_kpi_data_tables'||
2312: ' WHERE table_name = :1 AND data_source = :2'||
2313: ' AND mv_name <> :3';
2314: OPEN h_cursor FOR h_sql USING x_table_name, h_data_source_mv, x_mv_name;
2315: LOOP