186:
187: BEGIN
188:
189: IF l_period_type = 'FII_TIME_ENT_YEAR'
190: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
191: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
192: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
193: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
194: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
188:
189: IF l_period_type = 'FII_TIME_ENT_YEAR'
190: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
191: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
192: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
193: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
194: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
195: ELSE -- l_period_type = 'FII_TIME_WEEK'
196: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
190: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
191: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
192: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
193: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
194: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
195: ELSE -- l_period_type = 'FII_TIME_WEEK'
196: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
197: END IF;
198:
192: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
193: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
194: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
195: ELSE -- l_period_type = 'FII_TIME_WEEK'
196: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
197: END IF;
198:
199: l_cursor_id := DBMS_SQL.Open_Cursor;
200: l_stmt := '