DBA Data[Home] [Help]

APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on GL_PERIOD_STATUSES

Line 1225: ,gl_period_statuses p

1221:
1222: CURSOR c_period IS
1223: SELECT 'exist'
1224: FROM xla_ae_headers h
1225: ,gl_period_statuses p
1226: WHERE p.application_id(+) = C_GL_APPLICATION_ID
1227: AND p.ledger_id(+) = h.ledger_id
1228: AND p.adjustment_period_flag(+) = 'N'
1229: AND p.period_name(+) = h.period_name

Line 7536: FROM gl_period_statuses

7532: RETURN VARCHAR2
7533: IS
7534: CURSOR c IS
7535: SELECT closing_status, period_name, period_type
7536: FROM gl_period_statuses
7537: WHERE application_id = C_GL_APPLICATION_ID
7538: AND ledger_id = p_ledger_id
7539: AND adjustment_period_flag = 'N'
7540: AND p_accounting_date BETWEEN start_date AND end_date;