22:
23: ELSIF p_period_type_id=16 THEN
24:
25: SELECT start_date INTO l_start_date
26: FROM ozf_time_week
27: WHERE week_id=p_time_id;
28:
29: ELSIF p_period_type_id=32 THEN
30:
69:
70: ELSIF p_period_type_id=16 THEN
71:
72: SELECT end_date INTO l_end_date
73: FROM ozf_time_week
74: WHERE week_id=p_time_id;
75:
76: ELSIF p_period_type_id=32 THEN
77:
117:
118: ELSIF p_period_type_id=16 THEN
119:
120: SELECT name INTO l_name
121: FROM ozf_time_week
122: WHERE week_id=p_time_id;
123:
124: ELSIF p_period_type_id=32 THEN
125:
269: Cursor get_week_ids_csr (l_start_date date,
270: l_end_date date) IS
271: SELECT
272: week_id
273: FROM ozf_time_week
274: WHERE start_date >= l_start_date
275: AND end_date <= l_end_date;
276:
277: BEGIN