APPS.ISC_DBI_PLAN_SETUP_UTIL_PKG SQL Statements

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

Line: 17

	    select decode(ltrim(a2m_dblink, ' '), NULL, NULL, '@'||a2m_dblink)
	    into l_dblink
	    from mrp_ap_apps_instances_all;

Line: 27

	l_stmt := 'select ''Y'' from msc_plans'||l_dblink||' msc where :plan_name in msc.compile_designator '||
		  'and curr_plan_type <> 4';

Line: 85

	  l_stmt := 'select min(f.'||l_col_name||')+'||l_days_offset||' from '||
		    l_table_name||' f where f.'||l_col_name||' >= trunc(:reference_date)-'||l_days_offset;

Line: 88

  	  l_stmt := 'select min(f.'||l_col_name||')'||l_days_offset||' from '||
		    l_table_name||' f where f.'||l_col_name||' >= trunc(:reference_date)+'||abs(l_days_offset);

Line: 122

	 select get_next_collection_date(frequency, days_offset, sysdate+1)
	   into	l_next_collection_date
	   from	isc_dbi_plan_schedules
	  where	plan_name = p_plan_name;