APPS.XLA_ACCOUNTING_CACHE_PKG dependencies on GL_LEDGER_RELATIONSHIPS

Line 519: FROM gl_ledger_relationships glr

515: ,glr.ALC_DEFAULT_CONV_RATE_TYPE
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

Line 542: FROM gl_ledger_relationships glr2

538: )
539: AND (glr.org_id = -99
540: OR mo_global.check_access(glr.org_id) = 'Y')
541: AND glr.relationship_id IN (SELECT Max(glr2.relationship_id)
542: FROM gl_ledger_relationships glr2
543: WHERE glr2.primary_ledger_id = glr.primary_ledger_id
544: AND glr2.target_ledger_id = glr.target_ledger_id
545: AND glr2.application_id = glr.application_id
546: AND (glr2.org_id = -99