APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on DUAL

Line 717: FROM DUAL;

713:
714: -- Get Sequence Number to generate Contract Number
715: SELECT okl_rbk_seq.nextval
716: INTO l_seq_no
717: FROM DUAL;
718:
719: -- Get Contract Number from Original Contract
720: OPEN orig_csr(p_chr_id);
721: FETCH orig_csr INTO l_orig_contract_number;

Line 2405: l_reduce_residual_ptg_by NUMBER;

2401: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
2402: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
2403:
2404: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
2405: l_reduce_residual_ptg_by NUMBER;
2406: l_amount NUMBER := 0;
2407: l_principal_amount NUMBER := 0;
2408: l_principal_balance NUMBER := 0;
2409: l_acc_int NUMBER := 0;

Line 7185: FROM dual;

7181: WHERE id = p_chr_id;
7182:
7183: CURSOR c_tran_num_csr IS
7184: SELECT okl_sif_seq.nextval
7185: FROM dual;
7186:
7187: CURSOR c_stm_id_line_number(c_stm_id NUMBER) IS
7188: SELECT SE_LINE_NUMBER
7189: FROM OKL_STRM_ELEMENTS_V