DBA Data[Home] [Help]

APPS.XLA_TRANSFER_PKG dependencies on DUAL

Line 389: FROM dual;

385:
386:
387: CURSOR c_get_arrival_seq IS
388: SELECT gl_bc_packet_arrival_order_s.nextval
389: FROM dual;
390:
391:
392: CURSOR c_get_packet_id IS
393: SELECT gl_bc_packets_s.NEXTVAL

Line 394: FROM dual;

390:
391:
392: CURSOR c_get_packet_id IS
393: SELECT gl_bc_packets_s.NEXTVAL
394: FROM dual;
395:
396: --local Variables
397: l_log_module VARCHAR2(240);
398: l_packet_id NUMBER := 0;

Line 1323: into g_transaction_security from dual ;

1319: --added bug 14307411
1320: IF (g_security_id_int_1 IS NOT NULL) THEN
1321: select DECODE(g_application_id,707, ' AND NVL(xte.security_id_int_1,'|| g_security_id_int_1||') = ' ||g_security_id_int_1,
1322: ' AND xte.security_id_int_1 = '|| g_security_id_int_1)
1323: into g_transaction_security from dual ;
1324:
1325: END IF;
1326: -- end bug 14307411
1327: IF (g_security_id_int_2 IS NOT NULL) THEN

Line 3574: FROM dual;

3570: --For bug fix 7677948
3571: IF g_caller = C_ACCTPROG_BATCH AND g_transfer_mode = 'COMBINED' THEN
3572: SELECT gl_journal_import_s.NEXTVAL
3573: INTO g_primary_ledgers_tab(i).interface_run_id
3574: FROM dual;
3575: ELSE
3576: SELECT gl_journal_import_s.NEXTVAL
3577: ,gl_interface_control_s.NEXTVAL
3578: INTO g_primary_ledgers_tab(i).interface_run_id

Line 3580: FROM dual;

3576: SELECT gl_journal_import_s.NEXTVAL
3577: ,gl_interface_control_s.NEXTVAL
3578: INTO g_primary_ledgers_tab(i).interface_run_id
3579: ,g_primary_ledgers_tab(i).group_id
3580: FROM dual;
3581:
3582: --For bug fix 6941347
3583: g_arr_group_id(g_arr_group_id.COUNT +1):= g_primary_ledgers_tab(i).group_id;
3584: