APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_LEDGER_RELATIONSHIPS_V

Line 1076: ,xla_ledger_relationships_v xlr

1072:
1073: SELECT count(1)
1074: INTO l_sla_manual
1075: FROM xla_transaction_entities xte
1076: ,xla_ledger_relationships_v xlr
1077: WHERE xte.application_id=l_info.application_id
1078: AND xte.entity_id=l_info.entity_id
1079: AND xte.entity_code = 'MANUAL'
1080: AND xte.valuation_method is null

Line 2454: , xla_ledger_relationships_v xlr

2450: IF (l_info.balance_type_code <> 'B') THEN
2451: SELECT count(1)
2452: INTO l_sla_manual
2453: FROM xla_transaction_entities xte
2454: , xla_ledger_relationships_v xlr
2455: WHERE xte.application_id=l_info.application_id
2456: AND xte.entity_id=l_info.entity_id
2457: AND xte.entity_code = 'MANUAL'
2458: AND xte.valuation_method is null

Line 4180: , xla_ledger_relationships_v l

4176: */
4177: CURSOR c_mrc_headers IS
4178: SELECT xah.*
4179: FROM xla_ae_headers xah
4180: , xla_ledger_relationships_v l
4181: WHERE xah.application_id = p_info.application_id
4182: AND xah.event_id = p_orig_event_id
4183: AND xah.ledger_id = l.ledger_id
4184: -- AND l.primary_ledger_id = p_info.ledger_id -- bug#8736946

Line 5346: FROM xla_ledger_relationships_v xlr

5342: , xlr.currency_code ledger_currency
5343: , xlr.ALC_DEFAULT_CONV_RATE_TYPE
5344: , xlr.ALC_INHERIT_CONVERSION_TYPE
5345: , decode(xlr.ALC_NO_RATE_ACTION_CODE, 'FIND_RATE', nvl(xlr.ALC_MAX_DAYS_ROLL_RATE, -1), 0) max_roll_days
5346: FROM xla_ledger_relationships_v xlr
5347: ,fnd_currencies fcu
5348: WHERE xlr.primary_ledger_id = p_info.ledger_id
5349: AND xlr.relationship_enabled_flag = 'Y'
5350: AND xlr.ledger_category_code = 'ALC'

Line 6065: , xla_ledger_relationships_v l

6061:
6062: CURSOR c_entries IS
6063: SELECT h.ae_header_id
6064: FROM xla_ae_headers h
6065: , xla_ledger_relationships_v l
6066: WHERE h.event_id = p_event_id
6067: AND h.application_id = p_application_id
6068: AND h.ledger_id = l.ledger_id
6069: AND (l.LEDGER_CATEGORY_CODE IN ('ALC','SECONDARY')