APPS.OKL_ACCRUAL_SEC_PVT dependencies on DUAL

Line 864: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;

860: */
861: END IF;
862:
863: --Populate streams structure for primary product
864: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;
865: -- populate stream header record
866: l_stmv_rec.sty_id := l_sty_id;
867: l_stmv_rec.khr_id := l_contracts_csr.khr_id;
868: l_stmv_rec.sgn_code := 'MANL';

Line 883: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;

879:
880: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : begin ------------
881: IF l_rep_sty_id IS NOT NULL THEN
882: --Populate streams structure for reporting product
883: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;
884: -- populate stream header record
885: l_rep_stmv_rec.sty_id := l_rep_sty_id;
886: l_rep_stmv_rec.khr_id := l_contracts_csr.khr_id;
887: l_rep_stmv_rec.sgn_code := 'MANL';

Line 2069: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;

2065: */
2066: END IF; -- ELSIF
2067:
2068: --Populate streams structure for primary product
2069: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;
2070: -- populate stream header record
2071: l_stmv_rec.sty_id := l_sty_id;
2072: l_stmv_rec.khr_id := l_contracts_csr.khr_id;
2073: l_stmv_rec.sgn_code := 'MANL';

Line 2085: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;

2081:
2082: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : begin ------------
2083: IF l_rep_sty_id IS NOT NULL THEN
2084: --Populate streams structure for reporting product
2085: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;
2086: -- populate stream header record
2087: l_rep_stmv_rec.sty_id := l_rep_sty_id;
2088: l_rep_stmv_rec.khr_id := l_contracts_csr.khr_id;
2089: l_rep_stmv_rec.sgn_code := 'MANL';

Line 2625: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;

2621: */
2622: END IF;
2623:
2624: --Populate streams structure for primary product
2625: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;
2626: -- populate stream header record
2627: l_stmv_rec.sty_id := l_sty_id;
2628: l_stmv_rec.khr_id := l_contracts_csr.khr_id;
2629: l_stmv_rec.sgn_code := 'MANL';

Line 2644: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;

2640:
2641: ---------------sechawla 09-mar-09 : MG Impact on Investor Agreement : begin ------------
2642: IF l_rep_sty_id IS NOT NULL THEN
2643: --Populate streams structure for reporting product
2644: SELECT okl_sif_seq.NEXTVAL INTO l_trx_number FROM dual;
2645: -- populate stream header record
2646: l_rep_stmv_rec.sty_id := l_rep_sty_id;
2647: l_rep_stmv_rec.khr_id := l_contracts_csr.khr_id;
2648: l_rep_stmv_rec.sgn_code := 'MANL';