APPS.PA_PAXMGSLD_XMLP_PKG SQL Statements

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

Line: 31

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

Line: 40

    select distinct project_number into p_from_project
     from pa_proj_cost_subledger_v
     where project_id = p_project_id ;

Line: 46

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

Line: 58

  SELECT  gl.name
  INTO    l_name
  FROM    gl_sets_of_books gl
  WHERE   gl.set_of_books_id = p_ca_set_of_books_id;

Line: 87

	select currency_code
	into l_curr_code
	from gl_sets_of_books
	where set_of_books_id = p_ca_set_of_books_id;