DBA Data[Home] [Help]

APPS.GL_LEDGERS_PKG dependencies on GL_DATE_PERIOD_MAP

Line 3784: FROM gl_date_period_map

3780: AND period_type = x_period_type;
3781:
3782: CURSOR gap_exists IS
3783: SELECT accounting_date
3784: FROM gl_date_period_map
3785: WHERE period_name = not_assigned
3786: AND period_set_name = x_period_set_name
3787: AND period_type = x_period_type
3788: AND accounting_date BETWEEN beginning AND ending;

Line 3792: FROM gl_date_period_map

3788: AND accounting_date BETWEEN beginning AND ending;
3789:
3790: CURSOR gap_start IS
3791: SELECT max(accounting_date)
3792: FROM gl_date_period_map
3793: WHERE period_name <> not_assigned
3794: AND period_set_name = x_period_set_name
3795: AND period_type = x_period_type
3796: AND accounting_date < gap_date;

Line 3800: FROM gl_date_period_map

3796: AND accounting_date < gap_date;
3797:
3798: CURSOR gap_end IS
3799: SELECT min(accounting_date)
3800: FROM gl_date_period_map
3801: WHERE period_name <> not_assigned
3802: AND period_set_name = x_period_set_name
3803: AND period_type = x_period_type
3804: AND accounting_date > gap_date;