DBA Data[Home] [Help]

APPS.FUN_GL_BATCH_TRANSFER dependencies on DUAL

Line 192: select sysdate into l_init_sysdate from dual;

188: glps.period_name = periods.period_name AND
189: glps.application_id = 101 AND
190: glps.set_of_books_id = ledgers.ledger_id';
191:
192: select sysdate into l_init_sysdate from dual;
193:
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transfer Intercompany Transactions to General Ledger Report Date:'||to_char(sysdate,'DD-MON-YYYY HH:MM'));
195: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' GL Date From: ' || to_char(l_date_low, 'DD-MON-YYYY'));

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

450:
451: For o in c_import(p_request_id, l_source, l_category)
452: loop
453: -- get interface run id
454: select gl_journal_import_s.nextval into v_interface_run_id from dual;
455:
456: insert into gl_interface_control (je_source_name,
457: status,
458: set_of_books_id,