APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on DUAL

Line 1659: FROM dual;

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

Line 1783: FROM dual;

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

Line 2529: FROM dual;

2525:
2526: -- get sequence number
2527: SELECT cn_posting_batches_s.NEXTVAL
2528: INTO l_posting_batch_id
2529: FROM dual;
2530:
2531: -- Refresh payment transactions
2532: IF l_pay_by_mode = 'N'
2533: THEN

Line 2725: FROM dual;

2721: -- incentive type code
2722: -- get sequence number
2723: SELECT cn_posting_batches_s.NEXTVAL
2724: INTO carryover_posting_batch_id
2725: FROM dual;
2726:
2727: INSERT INTO cn_payment_transactions
2728: (payment_transaction_id,
2729: posting_batch_id,

Line 3138: FROM dual;

3134: THEN
3135: -- Get the Sequence Number
3136: SELECT cn_posting_batches_s.NEXTVAL
3137: INTO recv_posting_batch_id
3138: FROM dual;
3139:
3140: l_batch_rec.posting_batch_id := recv_posting_batch_id;
3141: l_batch_rec.NAME := 'PMTPLN batch number:' || wksht_rec.payrun_id || ':' || wksht_rec.salesrep_id || ':' ||
3142: l_calc_rec_tbl(i).quota_id || ':' || recv_posting_batch_id;

Line 4165: FROM sys.dual;

4161:
4162: -- Get logical batch ID
4163: SELECT cn_process_batches_s2.NEXTVAL
4164: INTO l_logical_batch_id
4165: FROM sys.dual;
4166:
4167: fnd_file.put_line(fnd_file.LOG,'Logical Batch ID in cn_process_batches_all = ' || l_logical_batch_id);
4168:
4169: FOR currbatch IN 1 .. l_max_batch_id

Line 4176: FROM sys.dual;

4172: /* Load batches into cn_process_batches*/
4173: -- sequence s1 is for Physical batch id
4174: SELECT cn_process_batches_s3.NEXTVAL
4175: INTO l_physical_batch_id
4176: FROM sys.dual;
4177:
4178: FOR kk IN 1 .. p_salesrep_tbl.COUNT
4179: LOOP
4180: IF (p_salesrep_tbl(kk).batch_id = currbatch)