DBA Data[Home] [Help]

APPS.GL_GLXETB_XMLP_PKG SQL Statements

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

Line: 51

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

    SELECT currency_code, object_type_code
    INTO   PARAM_LEDGER_CURR, PARAM_LEDGER_TYPE
    FROM   gl_ledgers
    WHERE  ledger_id = P_LEDGER_ID;
Line: 150

      SELECT substr(ltrim(to_char(11, '9G9')), 2, 1)
      INTO   THOUSANDS_SEPARATOR
      FROM   dual;
Line: 250

 Function SELECT_BAL_p return varchar2 is
	Begin
	 return SELECT_BAL;
Line: 254

 Function SELECT_ALL_p return varchar2 is
	Begin
	 return SELECT_ALL;
Line: 270

 Function SELECT_ACCT_p return varchar2 is
	Begin
	 return SELECT_ACCT;