174:
175: BEGIN
176:
177: IF l_period_type = 'FII_TIME_ENT_YEAR'
178: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
179: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
180: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
181: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
182: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
176:
177: IF l_period_type = 'FII_TIME_ENT_YEAR'
178: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
179: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
180: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
181: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
182: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
183: ELSE -- l_period_type = 'FII_TIME_WEEK'
184: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
178: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
179: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
180: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
181: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
182: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
183: ELSE -- l_period_type = 'FII_TIME_WEEK'
184: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
185: END IF;
186:
180: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
181: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
182: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
183: ELSE -- l_period_type = 'FII_TIME_WEEK'
184: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
185: END IF;
186:
187: l_cursor_id := DBMS_SQL.Open_Cursor;
188: l_stmt := '