APPS.XLA_ACCOUNTING_CACHE_PKG dependencies on GL_LEDGERS

Line 490: ,gl_ledgers l -- 14522783

486: FROM xla_ledger_relationships_v xlr
487: ,fnd_currencies fcu
488: -- the following is added for bug 4640689
489: ,xla_subledgers xsl
490: ,gl_ledgers l -- 14522783
491: WHERE xlr.primary_ledger_id = p_base_ledger_id
492: AND l.ledger_id = xlr.target_ledger_id --14522783
493: AND xlr.relationship_enabled_flag = 'Y'
494: AND xlr.ledger_category_code = 'ALC'

Line 520: ,gl_ledgers glg

516: ,decode(glr.ALC_NO_RATE_ACTION_CODE, 'FIND_RATE', nvl(glr.ALC_MAX_DAYS_ROLL_RATE, -1), 0)
517: ALC_MAX_DAYS_ROLL_RATE
518: ,glg.ROUNDING_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID -- added for bug14522783
519: FROM gl_ledger_relationships glr
520: ,gl_ledgers glg
521: ,fnd_currencies fcu
522: ,xla_subledgers xsl
523: WHERE glr.primary_ledger_id = p_base_ledger_id
524: AND glr.relationship_enabled_flag = 'Y'

Line 869: FROM gl_ledgers

865: -- >> valuation method enhanacements
866: --
867: SELECT ledger_category_code
868: INTO l_event_ledger_category
869: FROM gl_ledgers
870: WHERE ledger_id = p_event_ledger_id;
871: --
872: -- << valuation method enhanacements
873: --