APPS.FII_NON_DBI_TIME_C dependencies on FII_TIME_CAL_NAME

Line 40: select distinct cal.period_set_name, cal.period_type from fii_time_cal_name cal;

36:
37: cursor new_cal is
38: select distinct gl.period_set_name, gl.period_type from gl_periods gl
39: minus
40: select distinct cal.period_set_name, cal.period_type from fii_time_cal_name cal;
41:
42: begin
43:
44: -- ---------------------------------------------------------

Line 51: from fii_time_cal_name;

47: l_name_row := 0;
48:
49: select nvl(max(calendar_id),0)
50: into l_max_cal_name
51: from fii_time_cal_name;
52:
53: IF(FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, g_schema)) THEN
54: NULL;
55: END IF;

Line 62: insert into fii_time_cal_name

58: -- Populate Calendar Name Level
59: -- ----------------------
60: FOR new_cal_rec IN new_cal LOOP
61:
62: insert into fii_time_cal_name
63: (calendar_id,
64: period_set_name,
65: period_type,
66: name,

Line 92: gather_table_stats('FII_TIME_CAL_NAME');

88: commit;
89:
90: if l_name_row > 0 then
91:
92: gather_table_stats('FII_TIME_CAL_NAME');
93:
94: end if;
95:
96: end LOAD_CAL_NAME;