APPS.BSC_AW_READ dependencies on BSC_SYS_PERIODICITIES

Line 713: select calendar_id into l_calendar_id from bsc_sys_periodicities where periodicity_id=l_periodicity_id;

709: l_periodicity_id:=p_parameters(i).parameter_name;
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