APPS.ISC_DBI_PLAN_PARAM_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

	select id into stmt from isc_plan_snapshot_v where id<>-1 and rownum<2;

Line: 49

	select ent_period_id into stmt from fii_time_ent_period where sysdate between start_date and end_date;

Line: 66

  	select min(data_start_date) into l_return_date from isc_dbi_plan_snapshots;

Line: 83

  select max(cutoff_date) into l_return_date from isc_dbi_plan_snapshots;

Line: 103

	select ent_period_id into l_cur_period from fii_time_ent_period where trunc(sysdate) between start_date and end_date;