APPS.BSC_MO_HELPER_PKG dependencies on BSC_SYS_CALENDARS_B

Line 5931: FROM BSC_SYS_PERIODICITIES P, BSC_SYS_CALENDARS_B C

5927: --otherwise the period ned to be the current fiscal year of the calendar
5928: UPDATE BSC_KPI_PERIODICITIES K
5929: SET CURRENT_PERIOD =
5930: (SELECT DECODE(P.YEARLY_FLAG, 1, C.FISCAL_YEAR, 1)
5931: FROM BSC_SYS_PERIODICITIES P, BSC_SYS_CALENDARS_B C
5932: WHERE K.PERIODICITY_ID = P.PERIODICITY_ID
5933: AND P.CALENDAR_ID = C.CALENDAR_ID
5934: )
5935: WHERE INDICATOR = Indicador.Code;

Line 5972: BSC_SYS_CALENDARS_B C

5968: END
5969: FROM
5970: BSC_DB_COLOR_KPI_V K,
5971: BSC_SYS_PERIODICITIES P,
5972: BSC_SYS_CALENDARS_B C
5973: WHERE
5974: K.TAB_ID = D.TAB_ID AND
5975: K.INDICATOR = D.INDICATOR AND
5976: K.PERIODICITY_ID = P.PERIODICITY_ID AND

Line 6656: --Update range_yr_mod in BSC_SYS_CALENDARS_B

6652: WriteInitTable('ADV_SUM_LEVEL', BSC_METADATA_OPTIMIZER_PKG.g_Adv_Summarization_Level);
6653: End If;
6654:
6655:
6656: --Update range_yr_mod in BSC_SYS_CALENDARS_B
6657: UPDATE BSC_SYS_CALENDARS_B SET RANGE_YR_MOD = 0;
6658:
6659:
6660: IF BSC_METADATA_OPTIMIZER_PKG.gSYSTEM_STAGE = 2 THEN

Line 6657: UPDATE BSC_SYS_CALENDARS_B SET RANGE_YR_MOD = 0;

6653: End If;
6654:
6655:
6656: --Update range_yr_mod in BSC_SYS_CALENDARS_B
6657: UPDATE BSC_SYS_CALENDARS_B SET RANGE_YR_MOD = 0;
6658:
6659:
6660: IF BSC_METADATA_OPTIMIZER_PKG.gSYSTEM_STAGE = 2 THEN
6661: DropAppsTables;

Line 7288: from bsc_sys_calendars_b;

7284: where calendar_id=:1 and rownum=1';
7285:
7286: cursor cCalendars is
7287: select calendar_id, last_update_date
7288: from bsc_sys_calendars_b;
7289:
7290: l_option_string varchar2(100);
7291: l_error_message varchar2(4000);
7292: