APPS.GL_PERIOD_STATUSES_PKG dependencies on GL_DATE_PERIOD_MAP

Line 28: FROM gl_date_period_map

24: AND period_type = x_periodtype;
25:
26: CURSOR gap_exists IS
27: SELECT accounting_date
28: FROM gl_date_period_map
29: WHERE period_name = not_assigned
30: AND period_set_name = x_periodsetname
31: AND period_type = x_periodtype
32: AND accounting_date BETWEEN beginning AND ending;

Line 36: FROM gl_date_period_map

32: AND accounting_date BETWEEN beginning AND ending;
33:
34: CURSOR gap_start IS
35: SELECT max(accounting_date)
36: FROM gl_date_period_map
37: WHERE period_name <> not_assigned
38: AND period_set_name = x_periodsetname
39: AND period_type = x_periodtype
40: AND accounting_date < gap_date;

Line 44: FROM gl_date_period_map

40: AND accounting_date < gap_date;
41:
42: CURSOR gap_end IS
43: SELECT min(accounting_date)
44: FROM gl_date_period_map
45: WHERE period_name <> not_assigned
46: AND period_set_name = x_periodsetname
47: AND period_type = x_periodtype
48: AND accounting_date > gap_date;

Line 1237: gl_date_period_map dpm,

1233: ps.period_year, ps.period_num, ps.period_type
1234: INTO x_period_name, x_closing_status, x_period_year,
1235: x_period_num, x_period_type
1236: FROM gl_period_statuses ps,
1237: gl_date_period_map dpm,
1238: gl_ledgers led
1239: WHERE led.ledger_id = x_ledger_id
1240: AND dpm.accounting_date = x_given_date
1241: AND dpm.period_set_name = led.period_set_name