DBA Data[Home] [Help]

APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on GL_PERIOD_STATUSES

Line 1245: ,gl_period_statuses p

1241:
1242: CURSOR c_period IS
1243: SELECT 'exist'
1244: FROM xla_ae_headers h
1245: ,gl_period_statuses p
1246: WHERE p.application_id(+) = C_GL_APPLICATION_ID
1247: AND p.ledger_id(+) = h.ledger_id
1248: AND p.adjustment_period_flag(+) = 'N'
1249: AND p.period_name(+) = h.period_name

Line 7766: FROM gl_period_statuses

7762: RETURN VARCHAR2
7763: IS
7764: CURSOR c IS
7765: SELECT closing_status, period_name, period_type
7766: FROM gl_period_statuses
7767: WHERE application_id = C_GL_APPLICATION_ID
7768: AND ledger_id = p_ledger_id
7769: AND adjustment_period_flag = 'N'
7770: AND p_accounting_date BETWEEN start_date AND end_date;