126: end if;
127: begin
128: select t.period_year
129: into fiscal_year_s
130: from gl_periods t
131: where t.period_set_name = per_set
132: and t.period_type = per_type
133: and C_START_DATE between t.start_date and t.end_date
134: and t.adjustment_period_flag like
136: '%')
137: and rownum = 1;
138: select t.period_year
139: into fiscal_year_e
140: from gl_periods t
141: where t.period_set_name = per_set
142: and t.period_type = per_type
143: and C_END_DATE between t.start_date and t.end_date
144: and t.adjustment_period_flag like