APPS.BSC_MO_HELPER_PKG dependencies on BSC_SYS_PERIODICITIES

Line 3765: FROM BSC_SYS_PERIODICITIES sysper

3761: -- we should check for all existing periodicities in the system. Because in
3762: -- Initialize_periodicities we initialize array for all the periodicities in the system
3763: CURSOR cPeriods IS
3764: SELECT distinct sysper.PERIODICITY_ID, sysper.SOURCE
3765: FROM BSC_SYS_PERIODICITIES sysper
3766: ORDER BY PERIODICITY_ID;
3767: cPeriodRow cPeriods%ROWTYPE;
3768: cv CurTyp;
3769: l_temp NUMBER;

Line 3852: FROM BSC_SYS_PERIODICITIES_VL sysper

3848: -- in case of issues with BIS -> BSC calendar synching...
3849: CURSOR cPeriods IS
3850: SELECT distinct sysper.PERIODICITY_ID, sysper.SOURCE, sysper.EDW_FLAG, sysper.YEARLY_FLAG,
3851: sysper.CALENDAR_ID, NVL(sysper.PERIODICITY_TYPE, 0) AS PERIODICITY_TYPE
3852: FROM BSC_SYS_PERIODICITIES_VL sysper
3853: ORDER BY PERIODICITY_ID;
3854:
3855: cPeriodRow cPeriods%ROWTYPE;
3856:

Line 3994: FROM BSC_SYS_PERIODICITIES S

3990: NVL((SELECT MAX(NUM_OF_YEARS - PREVIOUS_YEARS)
3991: FROM BSC_KPI_PERIODICITIES
3992: WHERE NVL(NUM_OF_YEARS, 0) > 0 AND
3993: PERIODICITY_ID IN (SELECT PERIODICITY_ID
3994: FROM BSC_SYS_PERIODICITIES S
3995: WHERE S.CALENDAR_ID = B.CALENDAR_ID))
3996: , 1)
3997: ) AS MAX_FORYEAR,
3998: (

Line 4003: FROM BSC_SYS_PERIODICITIES S

3999: NVL((SELECT MAX(PREVIOUS_YEARS)
4000: FROM BSC_KPI_PERIODICITIES
4001: WHERE NVL(NUM_OF_YEARS, 0) > 0 AND
4002: PERIODICITY_ID IN (SELECT PERIODICITY_ID
4003: FROM BSC_SYS_PERIODICITIES S
4004: WHERE S.CALENDAR_ID = B.CALENDAR_ID))
4005: , 1)
4006: ) AS MAX_PREVIOUS,
4007: --Added 05/18/2005 after conversation with Venu

Line 5898: SELECT PERIODICITY_ID FROM BSC_SYS_PERIODICITIES

5894: --belonging to this calendar.
5895: --Remember that BSC Calendar is code -1 in gCalendars
5896: UPDATE BSC_DB_TABLES SET NUM_OF_YEARS = num_anos, PREVIOUS_YEARS = num_anosant
5897: WHERE PERIODICITY_ID IN (
5898: SELECT PERIODICITY_ID FROM BSC_SYS_PERIODICITIES
5899: WHERE CALENDAR_ID = Calendar.Code );
5900: IF Calendar.Source = 'BSC' THEN
5901: --BSC Calendar
5902: BSC_UPDATE_UTIL.Populate_Calendar_Tables(Calendar.Code);

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 5971: BSC_SYS_PERIODICITIES P,

5967: )
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