APPS.PA_PAXEXTAR_XMLP_PKG SQL Statements

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

Line: 58

SELECT
	name
,	segment1
  INTO
	prj_name
,	prj_num
  FROM
	pa_projects p
 WHERE
	p.project_id = PROJECT;

Line: 73

SELECT
	task_name
,	task_number
  INTO
	tsk_name
,	tsk_num
  FROM
	pa_tasks
 WHERE
	task_id = TASK;

Line: 101

  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: 120

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

Line: 136

	SELECT
		rpad( t.task_number, 18, ' ' )||
                rpad( t.task_name, 17, ' ' )
          INTO
	   	tsk
	  FROM
		pa_tasks t
	 WHERE
		t.task_id = t_id;

Line: 177

	SELECT
		substr((lpad( ' ', 2*(level-1) )||
		rpad( p.segment1, 18, ' ' )||
		rpad( p.name, 17, ' ' )), 1, 35 )
          INTO
		prj
	  FROM
		pa_projects p
	,	pa_tasks t
	 WHERE
		p.project_id = t.project_id
	   AND  t.task_id = t_id;