APPS.FII_SNAP_TBL_REFRESH dependencies on DUAL

Line 63: SELECT sysdate INTO g_fii_sysdate FROM dual;

59: -- Obtain user ID, login ID AND sysdate
60: g_fii_user_id := FND_GLOBAL.USER_ID;
61: g_fii_login_id := FND_GLOBAL.LOGIN_ID;
62:
63: SELECT sysdate INTO g_fii_sysdate FROM dual;
64:
65: g_phase := 'Check FII schema name AND other info';
66: -- If any of the above values is not set, error out
67: IF (g_fii_user_id is NULL OR g_fii_login_id is NULL) THEN

Line 157: FROM DUAL;

153: l_pq_this_date,
154: l_ly_this_date,
155: l_this_date_gov
156:
157: FROM DUAL;
158:
159: IF g_debug_flag = 'Y' THEN
160: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);
161: FII_UTIL.Write_Log ('>> l_pp_this_date = ' || l_pp_this_date);