APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on DUAL

Line 1657: FROM dual;

1653:
1654: -- get the posting batch id
1655: SELECT cn_posting_batches_s.NEXTVAL
1656: INTO cls_posting_batch_id
1657: FROM dual;
1658:
1659: -- if the payrun incentive type code is ALL
1660: -- we will set the incentive type as NULL
1661: -- which means we will get both Bonus and Commissions

Line 1781: FROM dual;

1777:
1778: -- Get the Sequence Number
1779: SELECT cn_posting_batches_s.NEXTVAL
1780: INTO recv_posting_batch_id
1781: FROM dual;
1782:
1783: l_batch_rec.posting_batch_id := recv_posting_batch_id;
1784: l_batch_rec.NAME := 'PMTPLN batch number:' || l_get_payrun_rec.payrun_id || ':' || p_worksheet_rec.salesrep_id || ':' ||
1785: l_calc_rec_tbl(i).quota_id || ':' || recv_posting_batch_id;

Line 2483: FROM dual;

2479:
2480: -- get sequence number
2481: SELECT cn_posting_batches_s.NEXTVAL
2482: INTO l_posting_batch_id
2483: FROM dual;
2484:
2485: -- Refresh payment transactions
2486: IF l_pay_by_mode = 'N'
2487: THEN

Line 2679: FROM dual;

2675: -- incentive type code
2676: -- get sequence number
2677: SELECT cn_posting_batches_s.NEXTVAL
2678: INTO carryover_posting_batch_id
2679: FROM dual;
2680:
2681: INSERT INTO cn_payment_transactions
2682: (payment_transaction_id,
2683: posting_batch_id,

Line 3092: FROM dual;

3088: THEN
3089: -- Get the Sequence Number
3090: SELECT cn_posting_batches_s.NEXTVAL
3091: INTO recv_posting_batch_id
3092: FROM dual;
3093:
3094: l_batch_rec.posting_batch_id := recv_posting_batch_id;
3095: l_batch_rec.NAME := 'PMTPLN batch number:' || wksht_rec.payrun_id || ':' || wksht_rec.salesrep_id || ':' ||
3096: l_calc_rec_tbl(i).quota_id || ':' || recv_posting_batch_id;

Line 4119: FROM sys.dual;

4115:
4116: -- Get logical batch ID
4117: SELECT cn_process_batches_s2.NEXTVAL
4118: INTO l_logical_batch_id
4119: FROM sys.dual;
4120:
4121: fnd_file.put_line(fnd_file.LOG,'Logical Batch ID in cn_process_batches_all = ' || l_logical_batch_id);
4122:
4123: FOR currbatch IN 1 .. l_max_batch_id

Line 4130: FROM sys.dual;

4126: /* Load batches into cn_process_batches*/
4127: -- sequence s1 is for Physical batch id
4128: SELECT cn_process_batches_s3.NEXTVAL
4129: INTO l_physical_batch_id
4130: FROM sys.dual;
4131:
4132: FOR kk IN 1 .. p_salesrep_tbl.COUNT
4133: LOOP
4134: IF (p_salesrep_tbl(kk).batch_id = currbatch)