DBA Data[Home] [Help]

APPS.CE_XLA_ACCT_EVENTS_PKG dependencies on GL_PERIOD_STATUSES

Line 24: FROM gl_period_statuses glp

20:
21: log('validate accounting date '|| X_accounting_date);
22: SELECT count(*)
23: INTO l_count
24: FROM gl_period_statuses glp
25: WHERE glp.ledger_id = X_ledger_id
26: AND glp.closing_status in ('O','F')
27: AND glp.application_id = 101
28: AND glp.adjustment_period_flag = 'N'

Line 39: FROM gl_period_statuses

35: ELSE
36: -- Return the next open GL date
37: SELECT MIN(start_date)
38: INTO l_accounting_date
39: FROM gl_period_statuses
40: WHERE closing_status = 'O'
41: AND ledger_id = X_ledger_id
42: AND application_id = 101
43: AND adjustment_period_flag = 'N'