APPS.CN_TRANSACTION_LOAD_PUB dependencies on DUAL

Line 39: FROM sys.dual;

35: BEGIN
36: -- sequence s3 is for physical batch id
37: SELECT cn_process_batches_s3.nextval
38: INTO x_physical_batch_id
39: FROM sys.dual;
40:
41: RETURN x_physical_batch_id;
42: EXCEPTION
43: WHEN no_data_found THEN raise NO_DATA_FOUND;

Line 127: INTO l_init_commission_header_id FROM dual;

123: END IF;
124:
125: -- this is used to make it more restrict for handling reversal trx later on
126: SELECT cn_commission_headers_s.NEXTVAL
127: INTO l_init_commission_header_id FROM dual;
128:
129: FOR batch IN batches LOOP
130:
131: debugmsg('Loader : Load_Worker : Load ' ||

Line 1195: -- Get individual physical batch id

1191: acc.period_id,
1192: acc.start_date,
1193: acc.end_date;
1194:
1195: -- Get individual physical batch id
1196: CURSOR physical_batches(l_logical_batch_id NUMBER) IS
1197: SELECT DISTINCT physical_batch_id
1198: FROM cn_process_batches
1199: WHERE logical_batch_id = l_logical_batch_id

Line 1395: FROM sys.dual;

1391:
1392: -- sequence s2 is for logical batch id
1393: SELECT cn_process_batches_s2.NEXTVAL
1394: INTO l_logical_batch_id
1395: FROM sys.dual;
1396:
1397:
1398: debugmsg('Loader : Logical batch id = '||l_logical_batch_id);
1399:

Line 1440: FROM sys.dual;

1436:
1437: -- sequence s1 is for process batch id
1438: SELECT cn_process_batches_s1.NEXTVAL
1439: INTO l_process_batch_id
1440: FROM sys.dual;
1441: debugmsg('Loader : insert into cn_process_batches....');
1442: debugmsg('l_process_batch_id = ' || l_process_batch_id);
1443: debugmsg('l_logical_batch_id = '||l_logical_batch_id);
1444: debugmsg('period_id = '||l_period_id_tbl(i) );