APPS.BSC_BSC_XTD_PKG dependencies on BSC_KPI_PERIODICITIES

Line 259: select bsc_kpi_periodicities.periodicity_id,calendar_id,period_type_id,db_column_name,num_of_periods

255: p_xtd_type varchar2
256: )return boolean is
257: ------
258: cursor c1(p_kpi number) is
259: select bsc_kpi_periodicities.periodicity_id,calendar_id,period_type_id,db_column_name,num_of_periods
260: from bsc_kpi_periodicities ,bsc_sys_periodicities
261: where indicator=p_kpi and bsc_kpi_periodicities.periodicity_id=bsc_sys_periodicities.periodicity_id
262: order by indicator,display_order desc;
263: cursor c2(p_xtd_periodicity number) is

Line 260: from bsc_kpi_periodicities ,bsc_sys_periodicities

256: )return boolean is
257: ------
258: cursor c1(p_kpi number) is
259: select bsc_kpi_periodicities.periodicity_id,calendar_id,period_type_id,db_column_name,num_of_periods
260: from bsc_kpi_periodicities ,bsc_sys_periodicities
261: where indicator=p_kpi and bsc_kpi_periodicities.periodicity_id=bsc_sys_periodicities.periodicity_id
262: order by indicator,display_order desc;
263: cursor c2(p_xtd_periodicity number) is
264: select xtd_pattern from bsc_sys_periodicities where periodicity_id=p_xtd_periodicity;

Line 261: where indicator=p_kpi and bsc_kpi_periodicities.periodicity_id=bsc_sys_periodicities.periodicity_id

257: ------
258: cursor c1(p_kpi number) is
259: select bsc_kpi_periodicities.periodicity_id,calendar_id,period_type_id,db_column_name,num_of_periods
260: from bsc_kpi_periodicities ,bsc_sys_periodicities
261: where indicator=p_kpi and bsc_kpi_periodicities.periodicity_id=bsc_sys_periodicities.periodicity_id
262: order by indicator,display_order desc;
263: cursor c2(p_xtd_periodicity number) is
264: select xtd_pattern from bsc_sys_periodicities where periodicity_id=p_xtd_periodicity;
265: cursor c3(p_calendar_id number) is