APPS.XLA_GL_TRANSFER_PKG dependencies on DUAL

Line 249: '.NEXTVAL from dual';

245:
246: END IF;
247:
248: statement := 'select ' || g_lines_sequence_name ||
249: '.NEXTVAL from dual';
250:
251: EXECUTE IMMEDIATE statement INTO l_linkid;
252:
253: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 386: FROM dual

382: g_enc_table_alias;
383: EXIT WHEN c_get_program_info%NOTFOUND;
384: statement :=
385: ' SELECT COUNT(*)
386: FROM dual
387: WHERE EXISTS (
388: SELECT ''x''
389: FROM ' || g_headers_table ||
390: ' WHERE accounting_date BETWEEN :b_begin_date AND :b_end_date

Line 2051: FROM dual

2047:
2048: -- check if there are budget entries processed
2049: SELECT COUNT(*)
2050: INTO l_budget_entries
2051: FROM dual
2052: WHERE EXISTS ( SELECT 'x'
2053: FROM gl_interface
2054: WHERE user_je_source_name = p_user_source_name
2055: AND group_id = p_group_id

Line 2552: FROM dual;

2548:
2549: -- Get Transfer Run Id
2550: SELECT xla_gl_transfer_runid_s.NEXTVAL
2551: INTO l_transfer_run_id
2552: FROM dual;
2553:
2554: -- Set the batch Name
2555:
2556: --Bug3196153. p_batch_name exceeds the limit of varchar2(30)

Line 2564: FROM dual;

2560: -- If GL is installed populate group id and inter_run_id;
2561: IF Nvl(l_gl_installed_flag,'N') = 'I' THEN
2562: SELECT gl_interface_control_s.NEXTVAL, gl_journal_import_s.NEXTVAL
2563: INTO l_group_id, l_interface_run_id
2564: FROM dual;
2565: END IF;
2566:
2567: ---------------------------------------------------------------------------
2568: IF (C_LEVEL_STATEMENT >= g_log_level) THEN