APPS.PA_PAXAUGLT_XMLP_PKG SQL Statements

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

Line: 14

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

    SELECT
      CURRENCY_CODE
    INTO L_CURR_CODE
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = P_CA_SET_OF_BOOKS_ID;

Line: 348

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

Line: 353

	  SELECT user_je_source_name INTO tmp_usr_je_sname
	  FROM gl_je_sources WHERE
	  je_source_name = 'Project Accounting' ;

Line: 359

	SELECT period_set_name INTO tmp_period_set
	FROM   gl_sets_of_books
	/*R12 Changes : As the parameter P_SOB_ID is removed , the parameter
	p_ca_set_of_books_id is used here. */
	WHERE  set_of_books_id = p_ca_set_of_books_id ;

Line: 367

		SELECT start_date INTO tmp_gl_start
		FROM   gl_periods
		WHERE  period_set_name = tmp_period_set
		AND    period_name = p_from_period ;

Line: 375

		SELECT end_date INTO tmp_gl_end
		FROM   gl_periods
		WHERE  period_set_name = tmp_period_set
		AND    period_name = p_to_period ;

Line: 393

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