APPS.BIS_COMMON_PARAMETERS SQL Statements

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

Line: 9

      select profile_option_id,	application_id
        from   fnd_profile_options
        where  profile_option_name = upper(pname)
        and    start_date_active  <= sysdate
        and    nvl(end_date_active, sysdate) >= sysdate;

Line: 16

      select profile_option_value
	from   fnd_profile_option_values
	where  profile_option_id = pid
	and    application_id    = aid
	and    level_id          = lid
	and    level_value       = lval;

Line: 379

        l_temp := 'select upper(sql_validation) from fnd_profile_options where profile_option_name = UPPER(:name)';

Line: 404

	l_stmt := 'SELECT LOOKUP_CODE, MEANING FROM (' || l_sql ||
		') WHERE LOOKUP_CODE = :val';

Line: 455

		p_attribute_values.delete;

Line: 554

      select min(para.value) into  l_parallel
	  from v$parameter para
	  where para.name in ('cpu_count','parallel_max_servers');

Line: 602

	SELECT current_date_id into l_date FROM bis_system_date;