DBA Data[Home] [Help]

APPS.FII_AR_TPDUE_TBL_REFRESH dependencies on DUAL

Line 64: SELECT sysdate INTO g_fii_sysdate FROM dual;

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

Line 155: FROM DUAL;*/

151: l_pq_this_date,
152: l_ly_this_date,
153: l_this_date_gov
154:
155: FROM DUAL;*/
156:
157: IF g_debug_flag = 'Y' THEN
158: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);
159: END IF;

Line 486: FROM DUAL;*/

482: l_pq_this_date,
483: l_ly_this_date,
484: l_this_date_gov
485:
486: FROM DUAL;*/
487:
488: IF g_debug_flag = 'Y' THEN
489: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);
490: END IF;