129:
130: begin
131:
132: if(period_type='YTD') then
133: l_date := fii_time_api.ent_cyr_start(as_of_date);
134:
135: elsif(period_type='QTD') then
136: l_date := fii_time_api.ent_cqtr_start(as_of_date);
137:
132: if(period_type='YTD') then
133: l_date := fii_time_api.ent_cyr_start(as_of_date);
134:
135: elsif(period_type='QTD') then
136: l_date := fii_time_api.ent_cqtr_start(as_of_date);
137:
138: elsif(period_type='MTD') then
139: l_date := fii_time_api.ent_cper_start(as_of_date);
140:
135: elsif(period_type='QTD') then
136: l_date := fii_time_api.ent_cqtr_start(as_of_date);
137:
138: elsif(period_type='MTD') then
139: l_date := fii_time_api.ent_cper_start(as_of_date);
140:
141: elsif(period_type = 'WTD') then
142: l_date := fii_time_api.cwk_start(as_of_date);
143:
138: elsif(period_type='MTD') then
139: l_date := fii_time_api.ent_cper_start(as_of_date);
140:
141: elsif(period_type = 'WTD') then
142: l_date := fii_time_api.cwk_start(as_of_date);
143:
144: end if;
145:
146: return l_date;
182: begin
183:
184: if(period_type='YTD') then
185:
186: l_date := fii_time_api.ent_sd_lyr_end(as_of_date);
187:
188: elsif(period_type='QTD') then
189:
190: if(comparison_type = 'Y') then
187:
188: elsif(period_type='QTD') then
189:
190: if(comparison_type = 'Y') then
191: l_date := fii_time_api.ent_sd_lysqtr_end(as_of_date);
192: else
193: l_date := fii_time_api.ent_sd_pqtr_end(as_of_date);
194: end if;
195:
189:
190: if(comparison_type = 'Y') then
191: l_date := fii_time_api.ent_sd_lysqtr_end(as_of_date);
192: else
193: l_date := fii_time_api.ent_sd_pqtr_end(as_of_date);
194: end if;
195:
196: elsif(period_type='MTD') then
197:
195:
196: elsif(period_type='MTD') then
197:
198: if(comparison_type = 'Y') then
199: l_date := fii_time_api.ent_sd_lysper_end(as_of_date);
200: else
201: l_date := fii_time_api.ent_sd_pper_end(as_of_date);
202: end if;
203:
197:
198: if(comparison_type = 'Y') then
199: l_date := fii_time_api.ent_sd_lysper_end(as_of_date);
200: else
201: l_date := fii_time_api.ent_sd_pper_end(as_of_date);
202: end if;
203:
204: elsif(period_type='WTD') then
205:
203:
204: elsif(period_type='WTD') then
205:
206: if(comparison_type = 'Y') then
207: l_date := fii_time_api.sd_lyswk(as_of_date);
208: else
209: l_date := fii_time_api.sd_pwk(as_of_date);
210: end if;
211:
205:
206: if(comparison_type = 'Y') then
207: l_date := fii_time_api.sd_lyswk(as_of_date);
208: else
209: l_date := fii_time_api.sd_pwk(as_of_date);
210: end if;
211:
212: end if;
213: