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
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;
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
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
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;