APPS.BSC_BSC_XTD_PKG dependencies on BSC_SYS_PERIODICITIES

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

Line 264: select xtd_pattern from bsc_sys_periodicities where periodicity_id=p_xtd_periodicity;

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
266: select decode(edw_calendar_id,1001,decode(edw_calendar_type_id,1,'DBI-ENT',null),null) from bsc_sys_calendars_b
267: where calendar_id=p_calendar_id;
268: ------

Line 794: select period_type_id into l_period_type_id from bsc_sys_periodicities where periodicity_id=p_periodicity;

790: */
791: function is_daily_periodicity(p_periodicity number) return boolean is
792: l_period_type_id number;
793: Begin
794: select period_type_id into l_period_type_id from bsc_sys_periodicities where periodicity_id=p_periodicity;
795: if l_period_type_id=1 then
796: return true;
797: else
798: return false;

Line 1001: select period_type_id,periodicity_id,db_column_name from bsc_sys_periodicities where periodicity_id=p_periodicity_id;

997: p_roll_flag varchar2
998: )return boolean is
999: --------
1000: cursor c1(p_periodicity_id number) is
1001: select period_type_id,periodicity_id,db_column_name from bsc_sys_periodicities where periodicity_id=p_periodicity_id;
1002: --------
1003: l_pid_missing number;
1004: l_periodicity_missing number;
1005: l_db_column_missing varchar2(200);