DBA Data[Home] [Help]

APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_LEDGER_OPTIONS

Line 5138: FROM gl_ledgers gl, xla_ledger_options xlo

5134: RETURN VARCHAR2
5135: IS
5136: CURSOR c_trx_ledger (p_trx_ledger_id INTEGER, p_application_id INTEGER) IS
5137: SELECT gl.name, gl.currency_code, gl.ledger_category_code, xlo.rounding_rule_code
5138: FROM gl_ledgers gl, xla_ledger_options xlo
5139: WHERE gl.ledger_id = p_trx_ledger_id
5140: AND xlo.application_id = p_application_id
5141: AND xlo.ledger_id = p_trx_ledger_id;
5142:

Line 6776: xla_ledger_options xlo

6772: 'SEGMENT29', ccid.segment29,
6773: 'SEGMENT30', ccid.segment30)
6774: FROM gl_ledgers gl,
6775: gl_code_combinations ccid,
6776: xla_ledger_options xlo
6777: WHERE ccid.code_combination_id = p_code_combination_id
6778: AND gl.ledger_id = p_ledger_id
6779: AND xlo.ledger_id = p_ledger_id
6780: AND xlo.application_id = p_application_id

Line 6831: FROM xla_ledger_options

6827: ,p_transfer_to_gl_mode_code OUT NOCOPY VARCHAR2)
6828: IS
6829: CURSOR c IS
6830: SELECT decode(transfer_to_gl_mode_code,'D','D','S')
6831: FROM xla_ledger_options
6832: WHERE application_id = p_application_id
6833: AND ledger_id = p_ledger_id;
6834: l_log_module VARCHAR2(240);
6835: BEGIN