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 2048: FROM dual

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

Line 2549: FROM dual;

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

Line 2561: FROM dual;

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