APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_POSTING_BATCHES

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;

Line 3681: DELETE FROM cn_posting_batches cnpb

3677: AND nvl(hold_flag, 'N') = 'Y';
3678: END IF;
3679:
3680: -- Delete the Posting Batches
3681: DELETE FROM cn_posting_batches cnpb
3682: WHERE cnpb.posting_batch_id IN (SELECT cnpd.posting_batch_id
3683: FROM cn_payment_transactions cnpd
3684: WHERE cnpd.payrun_id = wksht.payrun_id
3685: AND cnpd.credited_salesrep_id = wksht.salesrep_id