APPS.GL_LEDGERS_PKG dependencies on GL_PERIODS

Line 274: from gl_periods

270: l_complete_flag VARCHAR2(1);
271: l_status_code VARCHAR2(30);
272: CURSOR first_ledger_period IS
273: select period_name
274: from gl_periods
275: where period_set_name = x_period_set_name
276: and period_type = x_accounted_period_type
277: order by period_year, period_num;
278: CURSOR get_config_status IS

Line 3778: FROM gl_periods

3774: ending DATE;
3775:
3776: CURSOR period_set IS
3777: SELECT min(start_date) begins, max(end_date) ends
3778: FROM gl_periods
3779: WHERE period_set_name = x_period_set_name
3780: AND period_type = x_period_type;
3781:
3782: CURSOR gap_exists IS

Line 4012: FROM GL_PERIODS pr, GL_PERIOD_TYPES pty

4008: PROCEDURE check_calendar_35max_days(x_ledger_id IN NUMBER,
4009: x_35day_flag OUT NOCOPY VARCHAR2) IS
4010: CURSOR check_calendar IS
4011: SELECT max(pr.end_date - pr.start_date)+1
4012: FROM GL_PERIODS pr, GL_PERIOD_TYPES pty
4013: WHERE pr.period_type = pty.period_type
4014: AND ((pr.period_set_name, pr.period_type)
4015: IN (SELECT period_set_name, accounted_period_type
4016: FROM gl_ledgers where ledger_id = x_ledger_id))