DBA Data[Home] [Help]

APPS.GL_LEDGERS_PKG dependencies on GL_DATE_PERIOD_MAP

Line 3727: FROM gl_date_period_map

3723: AND period_type = x_period_type;
3724:
3725: CURSOR gap_exists IS
3726: SELECT accounting_date
3727: FROM gl_date_period_map
3728: WHERE period_name = not_assigned
3729: AND period_set_name = x_period_set_name
3730: AND period_type = x_period_type
3731: AND accounting_date BETWEEN beginning AND ending;

Line 3735: FROM gl_date_period_map

3731: AND accounting_date BETWEEN beginning AND ending;
3732:
3733: CURSOR gap_start IS
3734: SELECT max(accounting_date)
3735: FROM gl_date_period_map
3736: WHERE period_name <> not_assigned
3737: AND period_set_name = x_period_set_name
3738: AND period_type = x_period_type
3739: AND accounting_date < gap_date;

Line 3743: FROM gl_date_period_map

3739: AND accounting_date < gap_date;
3740:
3741: CURSOR gap_end IS
3742: SELECT min(accounting_date)
3743: FROM gl_date_period_map
3744: WHERE period_name <> not_assigned
3745: AND period_set_name = x_period_set_name
3746: AND period_type = x_period_type
3747: AND accounting_date > gap_date;