APPS.BSC_PERIODS_PUB dependencies on BSC_SYS_PERIODS

Line 129: FROM bsc_sys_periods

125: l_Periods VARCHAR2(32000);
126: l_Is_Daily_Periodicity BOOLEAN;
127: CURSOR C_Base_Daily_Periods IS
128: SELECT start_date,end_date
129: FROM bsc_sys_periods
130: WHERE periodicity_id = p_Periodicity_Id;
131: CURSOR C_Periods IS
132: SELECT start_period,end_period
133: FROM bsc_sys_periods

Line 133: FROM bsc_sys_periods

129: FROM bsc_sys_periods
130: WHERE periodicity_id = p_Periodicity_Id;
131: CURSOR C_Periods IS
132: SELECT start_period,end_period
133: FROM bsc_sys_periods
134: WHERE periodicity_id = p_Periodicity_Id;
135: BEGIN
136: IF(p_Base_Periodicity_Id IS NOT NULL) THEN
137: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Base_Periodicity_Id);

Line 606: ' FROM BSC_SYS_PERIODS_VL BP, BSC_SYS_CALENDARS_B BC ' ||

602: /*l_Sql_Stmt := ' CREATE OR REPLACE VIEW ' || x_Periodicity_View_Name||'(ID,VALUE,START_DATE,END_DATE) AS '||
603: ' SELECT BP.PERIOD_ID, BP.NAME, ' ||
604: ' BSC_PERIODS_UTILITY_PKG.Get_Start_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR), ' ||
605: ' BSC_PERIODS_UTILITY_PKG.Get_End_Period_Date(BC.CALENDAR_ID, BP.PERIODICITY_ID, BP.PERIOD_ID, BP.YEAR) ' ||
606: ' FROM BSC_SYS_PERIODS_VL BP, BSC_SYS_CALENDARS_B BC ' ||
607: ' WHERE BP.PERIODICITY_ID = ' || p_Periodicity_Id ||
608: ' AND BC.CALENDAR_ID = ' || p_Calendar_Id ||
609: ' ORDER BY BP.PERIOD_ID, BP.MONTH '; */
610:

Line 634: ' FROM BSC_SYS_PERIODS_VL BP, BSC_DB_CALENDAR C ' ||

630: l_Sql_Stmt := ' CREATE OR REPLACE VIEW ' || x_Periodicity_View_Name||'(ID,VALUE,START_DATE,END_DATE) AS '||
631: ' SELECT BP.PERIOD_ID, BP.NAME, ' ||
632: ' MIN(TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY, ''YYYY-MM-DD'')) START_DATE, ' ||
633: ' MAX(TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY, ''YYYY-MM-DD'')) END_DATE ' ||
634: ' FROM BSC_SYS_PERIODS_VL BP, BSC_DB_CALENDAR C ' ||
635: ' WHERE BP.PERIODICITY_ID = ' || p_Periodicity_Id ||
636: ' AND C.CALENDAR_ID = ' || p_Calendar_Id ||
637: ' AND BP.YEAR = C.YEAR ' ||
638: ' AND BP.PERIOD_ID = C.' || l_Period_DB_Col ||

Line 694: FROM BSC_SYS_PERIODS P

690: FUNCTION Get_Period_List (p_Periodicity_Id IN NUMBER)
691: RETURN VARCHAR2 IS
692: CURSOR C_Non_Daily_Periods_List IS
693: SELECT DISTINCT P.START_PERIOD, P.END_PERIOD, P.PERIOD_ID
694: FROM BSC_SYS_PERIODS P
695: WHERE P.PERIODICITY_ID = p_Periodicity_Id
696: ORDER BY P.PERIOD_ID;
697:
698: CURSOR c_Daily_Periods_List IS

Line 700: FROM BSC_SYS_PERIODS P

696: ORDER BY P.PERIOD_ID;
697:
698: CURSOR c_Daily_Periods_List IS
699: SELECT DISTINCT P.START_DATE, P.END_DATE, P.PERIOD_ID
700: FROM BSC_SYS_PERIODS P
701: WHERE P.PERIODICITY_ID = p_Periodicity_Id
702: ORDER BY P.PERIOD_ID;
703:
704: CURSOR c_Source_Type IS