DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on DUAL

Line 102: SELECT TO_CHAR(systimestamp,'SSSSSFF') INTO l_temp_code FROM dual;

98: p_module => l_log_module,
99: p_level => C_LEVEL_EVENT);
100: END IF;
101:
102: SELECT TO_CHAR(systimestamp,'SSSSSFF') INTO l_temp_code FROM dual;
103: l_temp_code := substr(p_amb_context_code,1,12) || '_'||
104: p_application_id || '_S_' ||l_temp_code;
105: l_code := substr(l_temp_code,1,30);
106:

Line 140: FROM dual

136: ,xla_environment_pkg.g_usr_id
137: ,sysdate
138: ,xla_environment_pkg.g_usr_id
139: ,xla_environment_pkg.g_login_id
140: FROM dual
141: WHERE NOT EXISTS (SELECT 1
142: FROM xla_appli_amb_contexts
143: WHERE staging_amb_context_code = l_code);
144: