APPS.OE_BIS_ALERTS dependencies on BIS_YEARS_V

Line 304: from bis_years_v

300:
301: begin
302: select to_char(start_date, 'DD-MON-YYYY'), to_char(end_date + 1,'DD-MON-YYYY')
303: into l_start_date , l_end_date
304: from bis_years_v
305: where period_set_name = substr(p_time_period, 1, instr(p_time_period,'+')-1) and
306: period_name = substr(p_time_period,instr(p_time_period,'+')+1, length(p_time_period)) and
307: rownum = 1;
308: exception