DBA Data[Home] [Help]

APPS.GL_GLXBTB_XMLP_PKG SQL Statements

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

Line: 45

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

  SELECT target_ledger_name
  INTO   ledgername
  FROM   gl_ledger_relationships
  WHERE  source_ledger_id = P_LEDGER_ID
  AND    target_ledger_id = P_LEDGER_ID
  AND    target_currency_code = P_LEDGER_CURRENCY;
Line: 160

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

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

 Function SELECT_ACCT_p return varchar2 is
	Begin
	 return SELECT_ACCT;