APPS.FII_BUDGET_FORECAST_C dependencies on FII_TIME_DAY

Line 241: FROM FII_TIME_DAY

237: IF (FIIBUUP_PURGE_TIME_UNIT = 'D') THEN
238: BEGIN
239: SELECT report_date_julian
240: INTO l_purge_time_id
241: FROM FII_TIME_DAY
242: WHERE report_date = FIIBUUP_PURGE_DATE;
243: EXCEPTION
244: WHEN NO_DATA_FOUND THEN
245: l_time_period_valid := FALSE;

Line 326: 'FROM GL_ROW_MULTIPLIERS glrm, FII_TIME_DAY d ' ||

322:
323: l_sqlstmt := l_sqlstmt ||
324: '(SELECT DECODE(glrm.multiplier, 1, d.week_id, ' ||
325: '2, d.ent_period_id, 3, d.ent_qtr_id, 4, d.ent_year_id) ' ||
326: 'FROM GL_ROW_MULTIPLIERS glrm, FII_TIME_DAY d ' ||
327: 'WHERE glrm.multiplier BETWEEN 1 AND 4 ' ||
328: 'AND d.report_date_julian = :l_purge_time_id) ';
329:
330: ELSIF (FIIBUUP_PURGE_TIME_UNIT = 'P') THEN

Line 1266: ' fii_time_day fday '||

1262: ' b.posted_date, b.code_combination_id, b.budget_version_id, '||
1263: ' b.last_update_date, b.last_updated_by, '||
1264: ' b.creation_date, b.created_by, b.last_update_login '||
1265: ' FROM fii_budget_stg b, '||
1266: ' fii_time_day fday '||
1267: ' WHERE b.day = fday.report_date_julian '||
1268: ' GROUP BY '||
1269: ' b.plan_type_code, b.ledger_id, b.company_id, b.cost_center_id, '||
1270: ' b.fin_category_id, b.category_id, b.user_dim1_id, b.user_dim2_id,'||