DBA Data[Home] [Help]

APPS.GLXJEENT_PKG dependencies on GL_PERIODS

Line 276: FROM gl_periods per

272: period_year IN OUT NOCOPY NUMBER,
273: period_num IN OUT NOCOPY NUMBER) IS
274: CURSOR get_latest_opened IS
275: SELECT period_name, start_date, end_date, period_year, period_num
276: FROM gl_periods per
277: WHERE period_set_name = x_period_set_name
278: AND period_type = x_period_type
279: AND NOT EXISTS
280: (SELECT 'unopened ledger'

Line 294: FROM gl_periods per

290: ORDER BY period_year * 10000 + period_num DESC;
291:
292: CURSOR get_earliest_future_ent IS
293: SELECT period_name, start_date, end_date, period_year, period_num
294: FROM gl_periods per
295: WHERE period_set_name = x_period_set_name
296: AND period_type = x_period_type
297: AND NOT EXISTS
298: (SELECT 'unopened ledger'