APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on DUAL

Line 235: -- Get individual physical batch id's for the entire logical batch

231: l_sleep_time_char VARCHAR2(30);
232: l_errbuf VARCHAR2(1000);
233: l_retcode NUMBER;
234:
235: -- Get individual physical batch id's for the entire logical batch
236: CURSOR physical_batches IS
237: SELECT DISTINCT sca_process_batch_id
238: FROM cn_sca_process_batches
239: WHERE logical_batch_id = x_logical_batch_id;

Line 533: FROM SYS.DUAL;

529: l_end_id := l_id;
530:
531: SELECT cn_sca_process_batches_s.NEXTVAL
532: INTO l_sca_process_batch_id
533: FROM SYS.DUAL;
534:
535: INSERT INTO cn_sca_process_batches
536: (
537: sca_process_batch_id

Line 595: FROM SYS.DUAL;

591: l_end_id := l_id;
592:
593: SELECT cn_sca_process_batches_s.NEXTVAL
594: INTO l_sca_process_batch_id
595: FROM SYS.DUAL;
596:
597: INSERT INTO cn_sca_process_batches
598: (
599: sca_process_batch_id

Line 644: FROM SYS.DUAL;

640: loop_count < l_worker_num OR(loop_count = l_worker_num AND l_physical_batch_size < 1)
641: ) THEN
642: SELECT cn_sca_process_batches_s.NEXTVAL
643: INTO l_sca_process_batch_id
644: FROM SYS.DUAL;
645:
646: INSERT INTO cn_sca_process_batches
647: (
648: sca_process_batch_id

Line 751: FROM SYS.DUAL;

747: --+ Call begin_batch to get process_audit_id for debug log file
748: --+
749: SELECT cn_sca_logical_batches_s.NEXTVAL
750: INTO l_logical_batch_id
751: FROM SYS.DUAL;
752:
753: debugmsg('Allocation Process : Start of Transfer');
754: debugmsg('Allocation Process : process_audit_id is ' || l_process_audit_id);
755: --dbms_output.put_line('Allocation Process : process_audit_id is ' || l_process_audit_id );

Line 3232: FROM dual;

3228: g_loaded_txn_rowid_tbl := g_rowid_tbl_type();
3229: g_loaded_txn_comid_tbl := g_comm_lines_api_id_tbl_type();
3230:
3231: SELECT TO_NUMBER(NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'),1)) INTO g_num_workers
3232: FROM dual;
3233:
3234: IF g_num_workers < 1
3235: THEN
3236: g_num_workers := 1;