DBA Data[Home] [Help]

APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_LEDGER_RELATIONSHIPS_V

Line 4056: , xla_ledger_relationships_v l

4052: */
4053: CURSOR c_mrc_headers IS
4054: SELECT xah.*
4055: FROM xla_ae_headers xah
4056: , xla_ledger_relationships_v l
4057: WHERE xah.application_id = p_info.application_id
4058: AND xah.event_id = p_orig_event_id
4059: AND xah.ledger_id = l.ledger_id
4060: AND l.primary_ledger_id = p_info.ledger_id

Line 5150: FROM xla_ledger_relationships_v xlr

5146: , xlr.currency_code ledger_currency
5147: , xlr.ALC_DEFAULT_CONV_RATE_TYPE
5148: , xlr.ALC_INHERIT_CONVERSION_TYPE
5149: , decode(xlr.ALC_NO_RATE_ACTION_CODE, 'FIND_RATE', nvl(xlr.ALC_MAX_DAYS_ROLL_RATE, -1), 0) max_roll_days
5150: FROM xla_ledger_relationships_v xlr
5151: ,fnd_currencies fcu
5152: WHERE xlr.primary_ledger_id = p_info.ledger_id
5153: AND xlr.relationship_enabled_flag = 'Y'
5154: AND xlr.ledger_category_code = 'ALC'