APPS.IBE_BI_PMV_UTIL_PVT dependencies on FII_TIME_ENT_PERIOD

Line 148: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN

144: IF(p_period_type = 'FII_TIME_ENT_YEAR') THEN
145: l_record_type_id := 119;
146: ELSIF(p_period_type = 'FII_TIME_ENT_QTR') THEN
147: l_record_type_id := 55;
148: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN
149: l_record_type_id := 23;
150: ELSE
151: l_record_type_id := 11;
152: END IF;

Line 172: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') 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:
176: l_prev_date := FII_TIME_API.sd_pwk(p_asof_date);

Line 183: ELSIF(p_period_type = 'FII_TIME_ENT_PERIOD') THEN

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);
187: END IF;

Line 296: FROM FII_TIME_ENT_period

292: sequence,
293: ent_year_id,
294:
295: start_date
296: FROM FII_TIME_ENT_period
297: WHERE p_date BETWEEN start_date AND end_date;
298:
299: Cursor c_min_date(p_sequence NUMBER,
300: p_year_id NUMBER)

Line 303: FROM FII_TIME_ENT_PERIOD

299: Cursor c_min_date(p_sequence NUMBER,
300: p_year_id NUMBER)
301: IS
302: SELECT start_date
303: FROM FII_TIME_ENT_PERIOD
304: WHERE sequence = p_sequence
305: AND ent_year_id = p_year_id;
306:
307: l_timespan NUMBER := 0;