DBA Data[Home] [Help]

APPS.BSC_UPDATE_SUM dependencies on BSC_SYS_PERIODICITIES

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: