DBA Data[Home] [Help]

APPS.GL_GLXCAR_XMLP_PKG dependencies on GL_CONSOLIDATION

Line 22: FROM gl_ledger_relationships glr, gl_consolidation gcs, gl_ledgers gll

18: method VARCHAR2(1);
19: description VARCHAR2(240);
20: CURSOR t_cursorLedgerName IS
21: SELECT glr.target_ledger_name
22: FROM gl_ledger_relationships glr, gl_consolidation gcs, gl_ledgers gll
23: WHERE gll.ledger_id = decode(gcs.from_currency_code,
24: 'STAT', gcs.from_ledger_id, gll.ledger_id)
25: AND glr.target_currency_code = decode(gcs.from_currency_code,
26: 'STAT', gll.currency_code, gcs.from_currency_code)

Line 192: from gl_consolidation glc

188: glc.from_ledger_id, glc.to_ledger_id,
189: glc.description
190: into cons_name, method, curr_code, from_ledgerid, to_ledgerid,
191: description
192: from gl_consolidation glc
193: where glc.consolidation_id = cons_id;
194:
195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN