116:
117:
118: l_cur_start := l_time_from;
119: l_cur_end := l_time_to;
120: l_pre_start := FII_TIME_API.ent_pper_start(l_time_from); -- get the previous month
121: l_pre_end := FII_TIME_API.ent_pper_end(l_time_to); -- get the previous month
122:
123: l_lang := USERENV('LANG');
124:
117:
118: l_cur_start := l_time_from;
119: l_cur_end := l_time_to;
120: l_pre_start := FII_TIME_API.ent_pper_start(l_time_from); -- get the previous month
121: l_pre_end := FII_TIME_API.ent_pper_end(l_time_to); -- get the previous month
122:
123: l_lang := USERENV('LANG');
124:
125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;