16:
17: IF p_period_type_id=1 THEN
18:
19: SELECT start_date INTO l_start_date
20: FROM ozf_time_day
21: WHERE report_date_julian=p_time_id;
22:
23: ELSIF p_period_type_id=16 THEN
24:
63:
64: IF p_period_type_id=1 THEN
65:
66: SELECT end_date INTO l_end_date
67: FROM ozf_time_day
68: WHERE report_date_julian=p_time_id;
69:
70: ELSIF p_period_type_id=16 THEN
71:
111:
112: IF p_period_type_id=1 THEN
113:
114: SELECT TO_CHAR(report_date) INTO l_name
115: FROM ozf_time_day
116: WHERE report_date_julian=p_time_id;
117:
118: ELSIF p_period_type_id=16 THEN
119: