APPS.GL_LEDGERS_PKG dependencies on GL_PERIODS

Line 271: from gl_periods

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

Line 3721: FROM gl_periods

3717: ending DATE;
3718:
3719: CURSOR period_set IS
3720: SELECT min(start_date) begins, max(end_date) ends
3721: FROM gl_periods
3722: WHERE period_set_name = x_period_set_name
3723: AND period_type = x_period_type;
3724:
3725: CURSOR gap_exists IS

Line 3955: FROM GL_PERIODS pr, GL_PERIOD_TYPES pty

3951: PROCEDURE check_calendar_35max_days(x_ledger_id IN NUMBER,
3952: x_35day_flag OUT NOCOPY VARCHAR2) IS
3953: CURSOR check_calendar IS
3954: SELECT max(pr.end_date - pr.start_date)+1
3955: FROM GL_PERIODS pr, GL_PERIOD_TYPES pty
3956: WHERE pr.period_type = pty.period_type
3957: AND ((pr.period_set_name, pr.period_type)
3958: IN (SELECT period_set_name, accounted_period_type
3959: FROM gl_ledgers where ledger_id = x_ledger_id))