APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_POSTING_BATCHES

Line 1655: SELECT cn_posting_batches_s.NEXTVAL

1651:
1652: CLOSE get_prd_statuses;
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

Line 1779: SELECT cn_posting_batches_s.NEXTVAL

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

Line 2481: SELECT cn_posting_batches_s.NEXTVAL

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

Line 2677: SELECT cn_posting_batches_s.NEXTVAL

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

Line 3090: SELECT cn_posting_batches_s.NEXTVAL

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

Line 3635: DELETE FROM cn_posting_batches cnpb

3631: AND nvl(hold_flag, 'N') = 'Y';
3632: END IF;
3633:
3634: -- Delete the Posting Batches
3635: DELETE FROM cn_posting_batches cnpb
3636: WHERE cnpb.posting_batch_id IN (SELECT cnpd.posting_batch_id
3637: FROM cn_payment_transactions cnpd
3638: WHERE cnpd.payrun_id = wksht.payrun_id
3639: AND cnpd.credited_salesrep_id = wksht.salesrep_id