165:
166: -- If Sequential
167: IF(p_comparison_type = 'SEQUENTIAL') THEN
168: IF(p_period_type = 'FII_TIME_ENT_YEAR') THEN
169: l_prev_date := FII_TIME_API.ent_sd_lyr_end(p_asof_date);
170: ELSIF(p_period_type = 'FII_TIME_ENT_QTR') THEN
171: l_prev_date := FII_TIME_API.ent_sd_pqtr_end(p_asof_date);
172: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN
173: l_prev_date := FII_TIME_API.ent_sd_pper_end(p_asof_date);
167: IF(p_comparison_type = 'SEQUENTIAL') THEN
168: IF(p_period_type = 'FII_TIME_ENT_YEAR') THEN
169: l_prev_date := FII_TIME_API.ent_sd_lyr_end(p_asof_date);
170: ELSIF(p_period_type = 'FII_TIME_ENT_QTR') THEN
171: l_prev_date := FII_TIME_API.ent_sd_pqtr_end(p_asof_date);
172: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN
173: l_prev_date := FII_TIME_API.ent_sd_pper_end(p_asof_date);
174: ELSE
175:
169: l_prev_date := FII_TIME_API.ent_sd_lyr_end(p_asof_date);
170: ELSIF(p_period_type = 'FII_TIME_ENT_QTR') THEN
171: l_prev_date := FII_TIME_API.ent_sd_pqtr_end(p_asof_date);
172: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN
173: l_prev_date := FII_TIME_API.ent_sd_pper_end(p_asof_date);
174: ELSE
175:
176: l_prev_date := FII_TIME_API.sd_pwk(p_asof_date);
177: END IF;
172: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN
173: l_prev_date := FII_TIME_API.ent_sd_pper_end(p_asof_date);
174: ELSE
175:
176: l_prev_date := FII_TIME_API.sd_pwk(p_asof_date);
177: END IF;
178: ELSE -- comparison type Year by Year
179: IF(p_period_type = 'FII_TIME_ENT_YEAR') THEN
180: l_prev_date := FII_TIME_API.ent_sd_lyr_end(p_asof_date);
176: l_prev_date := FII_TIME_API.sd_pwk(p_asof_date);
177: END IF;
178: ELSE -- comparison type Year by Year
179: IF(p_period_type = 'FII_TIME_ENT_YEAR') THEN
180: l_prev_date := FII_TIME_API.ent_sd_lyr_end(p_asof_date);
181: ELSIF(p_period_type = 'FII_TIME_ENT_QTR') THEN
182: l_prev_date := FII_TIME_API.ent_sd_lysqtr_end(p_asof_date);
183: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN
184: l_prev_date := FII_TIME_API.ent_sd_lysper_end(p_asof_date);
178: ELSE -- comparison type Year by Year
179: IF(p_period_type = 'FII_TIME_ENT_YEAR') THEN
180: l_prev_date := FII_TIME_API.ent_sd_lyr_end(p_asof_date);
181: ELSIF(p_period_type = 'FII_TIME_ENT_QTR') THEN
182: l_prev_date := FII_TIME_API.ent_sd_lysqtr_end(p_asof_date);
183: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN
184: l_prev_date := FII_TIME_API.ent_sd_lysper_end(p_asof_date);
185: ELSE
186: l_prev_date := FII_TIME_API.sd_lyswk(p_asof_date);
180: l_prev_date := FII_TIME_API.ent_sd_lyr_end(p_asof_date);
181: ELSIF(p_period_type = 'FII_TIME_ENT_QTR') THEN
182: l_prev_date := FII_TIME_API.ent_sd_lysqtr_end(p_asof_date);
183: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN
184: l_prev_date := FII_TIME_API.ent_sd_lysper_end(p_asof_date);
185: ELSE
186: l_prev_date := FII_TIME_API.sd_lyswk(p_asof_date);
187: END IF;
188: END IF;
182: l_prev_date := FII_TIME_API.ent_sd_lysqtr_end(p_asof_date);
183: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN
184: l_prev_date := FII_TIME_API.ent_sd_lysper_end(p_asof_date);
185: ELSE
186: l_prev_date := FII_TIME_API.sd_lyswk(p_asof_date);
187: END IF;
188: END IF;
189:
190: