APPS.FII_SNAP_TBL_REFRESH dependencies on FII_GL_BASE_MAP_MV

Line 98: -- FROM FII_GL_BASE_MAP_MV

94: ----------------------------------------------------
95: -- PROCEDURE REFRESH_GL_SNAP_F (private)
96: --
97: -- This procedure will (fully) refresh table FII_GL_SNAP_F
98: -- FROM FII_GL_BASE_MAP_MV
99: ----------------------------------------------------
100: PROCEDURE REFRESH_GL_SNAP_F IS
101:
102: l_this_date DATE;

Line 180: --Insert data FROM fii_gl_base_map_mv by joining to fii_time_structures.

176: END IF;
177:
178:
179: --------------------------------------------------------------------------
180: --Insert data FROM fii_gl_base_map_mv by joining to fii_time_structures.
181: --Here we calculate XTD amounts for all four days at same time; the sql
182: --query is similar to what we have for PMV reports (using bitand function)
183: --------------------------------------------------------------------------
184:

Line 701: fii_gl_base_map_mv b

697: g_fii_user_id,
698: g_fii_login_id
699:
700: FROM fii_time_structures cal,
701: fii_gl_base_map_mv b
702: WHERE cal.report_date in (l_this_date, l_pp_this_date,
703: l_pq_this_date, l_ly_this_date, l_this_date_gov)
704: AND cal.time_id = b.time_id
705: AND cal.period_type_id = b.period_type_id