APPS.XLA_AE_LINES_PKG dependencies on GL_LEDGERS

Line 6029: gl_ledgers gl,

6025:
6026: SELECT max(glp.start_date)
6027: INTO l_max_first_open_period
6028: FROM gl_period_statuses glp,
6029: gl_ledgers gl,
6030: gl_ledger_relationships glr
6031: WHERE glp.period_name = gl.first_ledger_period_name
6032: AND glp.ledger_id = gl.ledger_id
6033: AND glp.application_id = 101

Line 6079: FROM xla_ae_lines_gt gt1, gl_ledgers gll

6075:
6076:
6077: FOR c_not_reversed_entries IN
6078: (SELECT DISTINCT gt1.event_id, gt1.ledger_id
6079: FROM xla_ae_lines_gt gt1, gl_ledgers gll
6080: WHERE gt1.reversal_code = 'DUMMY_LR'
6081: AND gll.ledger_id = gt1.ledger_id
6082: AND gll.ledger_category_code <> 'PRIMARY'
6083: AND NOT EXISTS (SELECT 1

Line 7327: FROM xla_ae_lines_gt gt1, gl_ledgers gll

7323:
7324:
7325: FOR c_not_reversed_entries IN
7326: (SELECT DISTINCT gt1.event_id, gt1.ledger_id
7327: FROM xla_ae_lines_gt gt1, gl_ledgers gll
7328: WHERE gt1.reversal_code = 'DUMMY_TR'
7329: AND gll.ledger_id = gt1.ledger_id
7330: AND gll.ledger_category_code <> 'PRIMARY'
7331: AND NOT EXISTS (SELECT 1

Line 9671: ,gl_ledgers gl

9667: ,decode( fc2.derive_type, 'EURO', 'EURO', 'EMU',
9668: decode( sign( trunc(nvl(xal.currency_conversion_date, xeg.transaction_date)) -
9669: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
9670: FROM xla_ae_lines_gt xal
9671: ,gl_ledgers gl
9672: ,fnd_currencies fc
9673: ,fnd_currencies fc1
9674: ,fnd_currencies fc2
9675: ,xla_events_gt xeg

Line 11206: -- ,xla_gl_ledgers_v xgl

11202: ,xla_ae_headers xah
11203: ,xla_distribution_links xdl
11204: ,xla_ae_lines xal
11205: -- ,xla_ledger_relationships_v xlr
11206: -- ,xla_gl_ledgers_v xgl
11207: -- ,xla_ledger_options xlo
11208: WHERE xah.application_id = xdl.application_id
11209: AND xah.ae_header_id = xdl.ae_header_id
11210: AND xal.application_id = xdl.application_id

Line 11311: gl_ledgers gl,

11307: ,glp.start_date
11308:
11309: FROM xla_ae_lines_gt xal,
11310: fnd_application_vl fav,
11311: gl_ledgers gl,
11312: gl_period_statuses glp
11313: WHERE ((reversal_code = C_DUMMY_PRIOR
11314: AND (bflow_prior_entry_status_code IS NULL OR NVL(bflow_prior_entry_status_code,'N') = 'X')) -- 5132302
11315: OR reversal_code = C_MPA_PRIOR_ENTRY) -- 4655713b

Line 11677: , xla_gl_ledgers_v xgl -- 4478604

11673: , xla_ae_headers xah
11674: , xla_distribution_links xdl
11675: , xla_ae_lines xal
11676: , xla_ledger_relationships_v xlr -- 4478604
11677: , xla_gl_ledgers_v xgl -- 4478604
11678: , xla_ledger_options xlo -- 5204178
11679: WHERE xgl.ledger_id = xalg.ledger_id -- 4478604
11680: AND xlr.ledger_id = xgl.ledger_id -- 4478604
11681: AND xte.application_id = xalg.bflow_application_id

Line 12272: ,gl_ledgers gl

12268: -- Get the start_date of the Primary ledger
12269: SELECT glp.start_date
12270: INTO l_primary_start_date
12271: FROM gl_period_statuses glp
12272: ,gl_ledgers gl
12273: WHERE glp.period_name = gl.first_ledger_period_name
12274: AND glp.ledger_id = gl.ledger_id
12275: AND glp.application_id = 101
12276: AND gl.ledger_id = p_ledger_id;

Line 12476: ,xla_gl_ledgers_v xlr

12472: ,'N')
12473: ,'N') -- 5443083
12474: FROM xla_ae_lines_gt l
12475: ,xla_ae_headers_gt h
12476: ,xla_gl_ledgers_v xlr
12477: WHERE (reversal_code = C_DUMMY_SAME
12478: OR reversal_code = C_MPA_SAME_ENTRY) -- 4655713b
12479: AND l.ae_header_id = h.ae_header_id
12480: AND l.ledger_id = h.ledger_id -- 5443083