APPS.GL_GLXCAR_XMLP_PKG SQL Statements

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

Line: 21

  SELECT glr.target_ledger_name
  FROM gl_ledger_relationships glr, gl_consolidation gcs, gl_ledgers gll
  WHERE gll.ledger_id = decode(gcs.from_currency_code,
         'STAT', gcs.from_ledger_id, gll.ledger_id)
  AND glr.target_currency_code = decode(gcs.from_currency_code,
        'STAT', gll.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 = P_CONSOLIDATION_ID;

Line: 187

    select glc.name, glc.method, glc.from_currency_code,
           glc.from_ledger_id, glc.to_ledger_id,
           glc.description
    into cons_name, method, curr_code, from_ledgerid, to_ledgerid,
         description
    from gl_consolidation glc
    where glc.consolidation_id = cons_id;

Line: 235

 Function SELECT_TO_FLEX_p return varchar2 is
	Begin
	 return SELECT_TO_FLEX;

Line: 243

 Function SELECT_FROM_FLEX_p return varchar2 is
	Begin
	 return SELECT_FROM_FLEX;