DBA Data[Home] [Help]

APPS.GL_LEDGERS_PKG dependencies on GL_PERIOD_TYPES

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))