APPS.PA_PAXCCGLA_XMLP_PKG SQL Statements

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

Line: 29

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

Line: 34

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

Line: 39

	SELECT period_set_name INTO tmp_period_set
	FROM   gl_sets_of_books

	WHERE  set_of_books_id = p_ca_set_of_books_id ;

Line: 45

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

Line: 54

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

Line: 75

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

Line: 89

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

    SELECT
      CURRENCY_CODE
    INTO
      L_CURR_CODE
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = P_CA_SET_OF_BOOKS_ID;