DBA Data[Home] [Help]

APPS.XLA_AE_LINES_PKG dependencies on GL_PERIOD_STATUSES

Line 6160: FROM gl_period_statuses glp,

6156: -- find the latest 'first ledger open period name' of all the secondary/alc ledgers
6157:
6158: SELECT max(glp.start_date)
6159: INTO l_max_first_open_period
6160: FROM gl_period_statuses glp,
6161: gl_ledgers gl,
6162: gl_ledger_relationships glr
6163: WHERE glp.period_name = gl.first_ledger_period_name
6164: AND glp.ledger_id = gl.ledger_id

Line 11742: ,gl_period_statuses glp

11738: ,xte.entity_code
11739: FROM xla_ae_lines_gt xal
11740: ,fnd_application_vl fav
11741: ,gl_ledgers gl
11742: ,gl_period_statuses glp
11743: ,xla_transaction_entities_upg xte
11744: WHERE ((reversal_code = C_DUMMY_PRIOR
11745: AND NVL(bflow_prior_entry_status_code,'X') = 'X') -- 5132302
11746: OR reversal_code = C_MPA_PRIOR_ENTRY) -- 4655713b

Line 12731: FROM gl_period_statuses glp

12727:
12728: -- Get the start_date of the Primary ledger
12729: SELECT glp.start_date
12730: INTO l_primary_start_date
12731: FROM gl_period_statuses glp
12732: ,gl_ledgers gl
12733: WHERE glp.period_name = gl.first_ledger_period_name
12734: AND glp.ledger_id = gl.ledger_id
12735: AND glp.application_id = 101