APPS.PA_PAXRWPTY_XMLP_PKG SQL Statements

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

Line: 7

  SELECT  gl.name
  INTO    l_name
  FROM    gl_sets_of_books gl,pa_implementations pi
  WHERE   gl.set_of_books_id = pi.set_of_books_id;

Line: 48

 select
  meaning
 into
  message_name
 from
  pa_lookups
 where
    lookup_type = 'MESSAGE'
and lookup_code = 'NO_DATA_FOUND';

Line: 74

  select description
  from pa_budget_entry_methods
  where budget_entry_method_code = code;

Line: 95

   select resource_list_name
   from pa_resource_lists_active_v
   where resource_list_id = list_id;

Line: 132

select meaning
from pa_lookups
where lookup_type = type
and   lookup_code = code;

Line: 174

  SELECT segment1 INTO temp_proj_name FROM pa_projects
  WHERE  project_id = burden_sum_dest_project_id ;

Line: 185

	SELECT task_name INTO temp_task_name FROM pa_tasks
	WHERE  task_id = burden_sum_dest_task_id ;

Line: 196

	 SELECT SUBSTR(meaning,1,40) INTO temp_yesno FROM fnd_lookups
	 WHERE  lookup_type = 'YES_NO' AND lookup_code = burden_account_flag;

Line: 206

      SELECT SUBSTR(meaning,1,40) INTO temp_disp_meth FROM pa_lookups
             WHERE  lookup_type = 'BURDEN_ACCOUNTING'
             AND    lookup_code = burden_amt_display_method ;

Line: 231

select meaning into l_meaning from fnd_lookups
where lookup_type='YES_NO'
and lookup_code=baseline_funding_flag;

Line: 242

select meaning into l_meaning from fnd_lookups
where lookup_type='YES_NO'
and lookup_code=revaluate_funding_flag;

Line: 253

select meaning into l_meaning from fnd_lookups
where lookup_type='YES_NO'
and lookup_code=include_gains_losses_flag;