156: l_cur_end := l_time_from;
157:
158: FOR i IN 1..l_loop
159: LOOP
160: l_cur_end := FII_TIME_API.next_period_end_date(l_cur_end, l_period_type);
161: END LOOP;
162:
163: l_pre_start := FII_TIME_API.ent_pper_start(l_cur_start); -- get the previous month
164: l_pre_end := FII_TIME_API.ent_pper_end(l_cur_end); -- get the previous month
159: LOOP
160: l_cur_end := FII_TIME_API.next_period_end_date(l_cur_end, l_period_type);
161: END LOOP;
162:
163: l_pre_start := FII_TIME_API.ent_pper_start(l_cur_start); -- get the previous month
164: l_pre_end := FII_TIME_API.ent_pper_end(l_cur_end); -- get the previous month
165:
166:
167: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
160: l_cur_end := FII_TIME_API.next_period_end_date(l_cur_end, l_period_type);
161: END LOOP;
162:
163: l_pre_start := FII_TIME_API.ent_pper_start(l_cur_start); -- get the previous month
164: l_pre_end := FII_TIME_API.ent_pper_end(l_cur_end); -- get the previous month
165:
166:
167: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
168: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();