APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on GL_PERIOD_STATUSES

Line 228: FROM gl_period_statuses

224: BEGIN
225:
226: SELECT end_date --- removed start_date
227: INTO l_sec_alc_end_date
228: FROM gl_period_statuses
229: WHERE period_name = (SELECT latest_opened_period_name -- removed first_ledger_period_name
230: FROM gl_ledgers
231: WHERE ledger_id = l_primary_ledger_id) -- removed l_secondary_alc_ledger_id
232: AND ledger_id = l_primary_ledger_id

Line 884: FROM gl_period_statuses

880:
881:
882: SELECT start_date
883: INTO l_start_date
884: FROM gl_period_statuses
885: WHERE period_name = l_start_period
886: AND ledger_id = l_secondary_alc_ledger_id
887: AND application_id = 101;
888: --AND adjustment_period_flag <> 'Y'; --condition removed since first open period may be adjustment period??

Line 3116: FROM gl_period_statuses gls

3112:
3113:
3114: UPDATE xla_ae_headers xah
3115: SET period_name = (SELECT gls.period_name
3116: FROM gl_period_statuses gls
3117: WHERE gls.ledger_id = l_secondary_alc_ledger_id
3118: AND gls.application_id = 101
3119: AND gls.adjustment_period_flag = 'N'
3120: AND xah.accounting_date BETWEEN gls.start_date AND gls.end_date