APPS.GL_GLXAVTRB_XMLP_PKG SQL Statements

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

Line: 7

    SELECT name, chart_of_accounts_id
    INTO   ACCESS_SET_NAME, STRUCT_NUM
    FROM   gl_access_sets
    WHERE  access_set_id = P_ACCESS_SET_ID;

Line: 23

    SELECT
      dpm.period_name,
      prd.start_date,
      prd.quarter_start_date,
      prd.year_start_date
    INTO
      PERIOD_NAME,
      PERIOD_START_DATE,
      QUARTER_START_DATE,
      YEAR_START_DATE
    FROM
      gl_access_sets       acc,
      gl_date_period_map   dpm,
      gl_periods           prd
    WHERE
        acc.access_set_id	= P_ACCESS_SET_ID
    AND dpm.period_set_name	= acc.period_set_name
    AND dpm.period_type		= acc.accounted_period_type
    AND dpm.accounting_date	= P_REPORTING_DATE
    AND prd.period_set_name	= dpm.period_set_name
    AND prd.period_name		= dpm.period_name
    AND prd.period_type		= dpm.period_type;

Line: 71

    SELECT
	PRECISION,
	MINIMUM_ACCOUNTABLE_UNIT
    INTO
	PRECISION,
	MAU
    FROM
	FND_CURRENCIES
    WHERE
	CURRENCY_CODE = RESULTING_CURRENCY;

Line: 316

 Function SELECT_BAL_p return varchar2 is
	Begin
	 return SELECT_BAL;

Line: 320

 Function SELECT_FLEXDATA_p return varchar2 is
	Begin
	 return SELECT_FLEXDATA;