APPS.FUN_GL_BATCH_TRANSFER dependencies on DUAL

Line 184: select sysdate into l_init_sysdate from dual;

180: glps.period_name = periods.period_name AND
181: glps.application_id = 101 AND
182: glps.set_of_books_id = ledgers.ledger_id';
183:
184: select sysdate into l_init_sysdate from dual;
185:
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to General Ledger Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
187: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));

Line 444: select gl_journal_import_s.nextval into v_interface_run_id from dual;

440:
441: For o in c_import(p_request_id, l_source, l_category)
442: loop
443: -- get interface run id
444: select gl_journal_import_s.nextval into v_interface_run_id from dual;
445:
446: insert into gl_interface_control (je_source_name,
447: status,
448: set_of_books_id,