DBA Data[Home] [Help]

APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_LEDGER_OPTIONS

Line 5334: FROM gl_ledgers gl, xla_ledger_options xlo

5330: RETURN VARCHAR2
5331: IS
5332: CURSOR c_trx_ledger (p_trx_ledger_id INTEGER, p_application_id INTEGER) IS
5333: SELECT gl.name, gl.currency_code, gl.ledger_category_code, xlo.rounding_rule_code
5334: FROM gl_ledgers gl, xla_ledger_options xlo
5335: WHERE gl.ledger_id = p_trx_ledger_id
5336: AND xlo.application_id = p_application_id
5337: AND xlo.ledger_id = p_trx_ledger_id;
5338:

Line 6996: xla_ledger_options xlo

6992: 'SEGMENT29', ccid.segment29,
6993: 'SEGMENT30', ccid.segment30)
6994: FROM gl_ledgers gl,
6995: gl_code_combinations ccid,
6996: xla_ledger_options xlo
6997: WHERE ccid.code_combination_id = p_code_combination_id
6998: AND gl.ledger_id = p_ledger_id
6999: AND xlo.ledger_id = p_ledger_id
7000: AND xlo.application_id = p_application_id

Line 7051: FROM xla_ledger_options

7047: ,p_transfer_to_gl_mode_code OUT NOCOPY VARCHAR2)
7048: IS
7049: CURSOR c IS
7050: SELECT decode(transfer_to_gl_mode_code,'D','D','S')
7051: FROM xla_ledger_options
7052: WHERE application_id = p_application_id
7053: AND ledger_id = p_ledger_id;
7054: l_log_module VARCHAR2(240);
7055: BEGIN