APPS.PA_PAXPRWBS_XMLP_PKG SQL Statements

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

Line: 52

    select task_name,task_number
    into tsk_name,tsk_number
    from pa_tasks where top_task_id1 = task_id;

Line: 61

    select segment1,name
    into proj_number,proj_name
    from pa_projects where proj = project_id;

Line: 83

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

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