APPS.GL_GLCRDR_XMLP_PKG SQL Statements

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

Line: 8

  select name, from_currency_code
  into   cons_name, curr_code
  from gl_consolidation
  where consolidation_id = cons_id;

Line: 35

      select jeb.name, jeb.default_period_name
      into batch_name, to_period
      from gl_je_batches jeb,
           gl_je_headers jeh,
           gl_je_lines    jel
      where jeb.je_batch_id = batch_id
      and  jeh.je_batch_id = jeb.je_batch_id
      and  (jeh.display_alc_journal_flag is null or jeh.display_alc_journal_flag = 'Y')
      and  jel.je_header_id = jeh.je_header_id
      and  rownum < 2;

Line: 58

      select jir.reference_3, jir.reference_1, jir.reference_4
      into  s_header_id, s_consolidation_id, s_ccid
      from gl_import_references jir, gl_je_headers jeh
      where jeh.je_batch_id = batch_id
      and   jir.je_header_id = jeh.je_header_id
      and   rownum < 2;

Line: 78

      select jeh.ledger_id
      into  from_ledid
      from  gl_je_headers jeh
      where jeh.je_header_id = header_id;

Line: 93

      select gca.to_ledger_id
      into to_ledid
      from gl_consolidation gca
      where  gca.consolidation_id = cons_id ;

Line: 145

  SELECT name
  INTO   DAS_NAME
  FROM   gl_access_sets
  WHERE  access_set_id = P_ACCESS_SET_ID;

Line: 242

  SELECT glr.target_ledger_name
  INTO FROM_LEDGER_NAME
  FROM gl_ledger_relationships glr, gl_consolidation gcs
  WHERE glr.target_currency_code = gcs.from_currency_code
  AND glr.source_ledger_id = gcs.from_ledger_id
  AND glr.target_ledger_id = gcs.from_ledger_id
  AND gcs.consolidation_id = cons_id;

Line: 332

 Function SELECT_TO_FLEX_p return varchar2 is
	Begin
	 return SELECT_TO_FLEX;

Line: 340

 Function SELECT_FROM_FLEX_p return varchar2 is
	Begin
	 return SELECT_FROM_FLEX;