APPS.GL_GLXUSA_XMLP_PKG SQL Statements

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

Line: 117

  SELECT glr.target_ledger_name
  INTO SubsidLedgerName
  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 = P_CONSOLIDATION_ID;

Line: 168

P1  := ' EXISTS ( SELECT	sysdate ' ;

Line: 178

P10_2:='        (SELECT MAX(glh2.consolidation_run_id) ';

Line: 295

	SELECT period_set_name INTO PeriodSetName
	FROM   GL_LEDGERS
	WHERE  ledger_id = SubsidLedgerID;

Line: 319

    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_ledid, to_ledid,
         description
    from gl_consolidation glc
    where glc.consolidation_id = cons_id;

Line: 341

    SELECT 'Y' INTO P_Accounts_Clause
    FROM   GL_CONSOLIDATION_ACCOUNTS CA
    WHERE  CA.consolidation_id = cons_id
    AND    CA.consolidation_run_id =
           ( SELECT max(CH.consolidation_run_id)
             FROM   GL_CONSOLIDATION_HISTORY CH
             WHERE  CH.consolidation_id = cons_id
             AND    CH.average_consolidation_flag = avg_flag
             AND    CH.actual_flag = actual_flag
             AND    CH.amount_type = amount_type )
    AND ROWNUM < 2;