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 1193: -- Get individual physical batch id

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

Line 1393: FROM sys.dual;

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

Line 1438: FROM sys.dual;

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