40:
41: ELSIF p_period_type_id=128 THEN
42:
43: SELECT start_date INTO l_start_date
44: FROM ozf_time_ent_year
45: WHERE ent_year_id=p_time_id;
46:
47: END IF;
48:
87:
88: ELSIF p_period_type_id=128 THEN
89:
90: SELECT end_date INTO l_end_date
91: FROM ozf_time_ent_year
92: WHERE ent_year_id=p_time_id;
93:
94: END IF;
95:
135:
136: ELSIF p_period_type_id=128 THEN
137:
138: SELECT name INTO l_name
139: FROM ozf_time_ent_year
140: WHERE ent_year_id=p_time_id;
141:
142: END IF;
143:
173:
174: ELSIF p_period_type_id=128 THEN
175:
176: SELECT name INTO l_name
177: FROM ozf_time_ent_year
178: WHERE ent_year_id=l_time_id;
179:
180: END IF;
181:
245: Cursor get_year_ids_csr (l_start_date date,
246: l_end_date date) IS
247: SELECT
248: ent_year_id
249: FROM ozf_time_ent_year
250: WHERE start_date >= l_start_date
251: AND end_date <= l_end_date;
252:
253: Cursor get_qtr_ids_csr (l_start_date date,