APPS.BSC_UPDATE_COLOR dependencies on BSC_DB_CALENDAR

Line 923: from bsc_db_calendar

919: IF h_yearly_flag = 1 THEN
920: -- Annual periodicity
921: select min(year), max(year)
922: into h_min_per, h_max_per
923: from bsc_db_calendar
924: where calendar_id = h_calendar_id;
925:
926: h_per_parameter_value := h_min_per||'.'||h_min_per||' TO '||h_max_per||'.'||h_max_per;
927: ELSE

Line 931: ' from bsc_db_calendar'||

927: ELSE
928: -- Other periodicity
929: h_sql := 'select min('||BSC_UPDATE_UTIL.Get_Calendar_Table_Col_Name(x_periodicity_id)||'),'||
930: ' max('||BSC_UPDATE_UTIL.Get_Calendar_Table_Col_Name(x_periodicity_id)||')'||
931: ' from bsc_db_calendar'||
932: ' where calendar_id = :1 and year = :2';
933: OPEN h_cursor FOR h_sql USING h_calendar_id, x_current_fy;
934: FETCH h_cursor INTO h_min_per, h_max_per;
935: CLOSE h_cursor;

Line 1871: ' FROM BSC_DB_CALENDAR'||

1867: -- BSC periodicity
1868: h_sql := 'INSERT /*+ append */ INTO BSC_TMP_ALL_PERIODS'||
1869: ' SELECT DISTINCT ' || BSC_UPDATE_UTIL.Get_Calendar_Table_Col_Name(l_objective_color_props.periodicity_id) ||
1870: ' AS PERIOD'||
1871: ' FROM BSC_DB_CALENDAR'||
1872: ' WHERE YEAR = :1 AND CALENDAR_ID = :2';
1873: h_bind_vars_values.delete;
1874: h_bind_vars_values(1) := h_current_fy;
1875: h_bind_vars_values(2) := h_calendar_id;