APPS.BSC_AW_READ dependencies on BSC_DB_CALENDAR

Line 714: select max(year) into l_max_period from bsc_db_calendar where calendar_id=l_calendar_id;

710: end if;
711: end loop;
712:
713: select calendar_id into l_calendar_id from bsc_sys_periodicities where periodicity_id=l_periodicity_id;
714: select max(year) into l_max_period from bsc_db_calendar where calendar_id=l_calendar_id;
715: select min(year) into l_min_period from bsc_db_calendar where calendar_id=l_calendar_id;
716:
717: -- set the upper and lower periods based on the above query
718: if to_number(substr(p_lower_period,1,instr(p_lower_period,'.')-1)) < l_min_period then

Line 715: select min(year) into l_min_period from bsc_db_calendar where calendar_id=l_calendar_id;

711: end loop;
712:
713: select calendar_id into l_calendar_id from bsc_sys_periodicities where periodicity_id=l_periodicity_id;
714: select max(year) into l_max_period from bsc_db_calendar where calendar_id=l_calendar_id;
715: select min(year) into l_min_period from bsc_db_calendar where calendar_id=l_calendar_id;
716:
717: -- set the upper and lower periods based on the above query
718: if to_number(substr(p_lower_period,1,instr(p_lower_period,'.')-1)) < l_min_period then
719: p_lower_period:=l_min_period||'.'||l_min_period;