DBA Data[Home] [Help]

APPS.XLA_AE_LINES_PKG dependencies on GL_PERIOD_STATUSES

Line 6028: FROM gl_period_statuses glp,

6024: -- find the latest 'first ledger open period name' of all the secondary/alc ledgers
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

Line 11312: gl_period_statuses glp

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
11316: AND fav.application_id(+) = xal.bflow_application_id

Line 12271: FROM gl_period_statuses glp

12267:
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