APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_POSTING_BATCHES_S

Line 1657: SELECT cn_posting_batches_s.NEXTVAL

1653:
1654: CLOSE get_prd_statuses;
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

Line 1781: SELECT cn_posting_batches_s.NEXTVAL

1777: p_worksheet_rec.org_id,
1778: l_get_payrun_rec.pay_date);
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;

Line 2527: SELECT cn_posting_batches_s.NEXTVAL

2523: RAISE fnd_api.g_exc_error;
2524: END IF;
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

Line 2723: SELECT cn_posting_batches_s.NEXTVAL

2719:
2720: -- Bug 2819874 :Add in carry over record if exist,regardless
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

Line 3136: SELECT cn_posting_batches_s.NEXTVAL

3132:
3133: IF SQL%ROWCOUNT = 0
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;