[Home] [Help]
5369:
5370: ----------------------------------------------------------------
5371: -- Declare variable interest parameter cursor
5372: -----------------------------------------------------------------
5373: --dkagrawa changed query to use okl_prod_qlty_val_uv than okl_product_parameter_v for performance
5374: CURSOR c_int_param(cp_rate_param_rowid ROWID) IS
5375: SELECT krp.interest_index_id
5376: , NVL(krp.base_rate, 0) base_rate
5377: , NVL(krp.interest_start_date, chr.start_date) interest_start_date
5403: , NULL pay_freq
5404: FROM okl_k_rate_params krp
5405: , okl_k_headers khr
5406: , okc_k_headers_b chr
5407: , okl_prod_qlty_val_uv ppm
5408: WHERE krp.rowid = cp_rate_param_rowid
5409: AND krp.khr_id = khr.id
5410: AND khr.id = chr.id
5411: --AND TRUNC(SYSDATE) BETWEEN krp.effective_from_date and NVL(krp.effective_to_date, trunc(SYSDATE))
10249: l_interest_rate okl_var_int_params.INTEREST_RATE%type;
10250: l_rebook_flag BOOLEAN := TRUE;
10251: l_interest_calc_end_date DATE;
10252: -- End by prasjain bug# 6142095
10253: --dkagrawa changed query to use view okl_prod_qlty_val_uv than okl_product_parameters_v for performance
10254: CURSOR c_chr_id (cp_khr_id VARCHAR2) IS
10255: SELECT okc.contract_number
10256: , NVL(okl.date_last_interim_interest_cal, okc.start_date) start_date
10257: , okl.deal_type deal_type
10259: , okc.authoring_org_id
10260: , round(months_between(okc.end_date, okl.date_last_interim_interest_cal)) remaining_term_in_months
10261: FROM okc_k_headers_b okc
10262: , okl_k_headers okl
10263: , okl_prod_qlty_val_uv ppm
10264: WHERE okc.id = cp_khr_id
10265: AND okl.id = okc.id
10266: AND okl.pdt_id = ppm.pdt_id
10267: AND ppm.quality_name = 'INTEREST_CALCULATION_BASIS';