[Home] [Help]
362: -- Modified cursor to fetch Index Name from Prefunding Terms
363: -- and Conditions
364: CURSOR indx_csr(p_chr_id IN NUMBER) IS
365: SELECT idx.name
366: FROM OKC_RULES_B rule, OKL_INDICES idx, OKC_RULE_GROUPS_B rgp
367: WHERE rule.rule_information_category = 'LAIVAR'
368: AND rule.dnz_chr_id = p_chr_id
369: AND rule.rule_information2 = idx.id
370: AND rule.rgp_id = rgp.id
378: -- changes made as part of OKLR12B disbursements project.
379: CURSOR change_csr(v_khr_id NUMBER,
380: v_start_date DATE,
381: v_end_date DATE,
382: v_name OKL_INDICES.NAME%TYPE) IS
383: SELECT ac.check_date change_date
384: FROM OKL_TRX_AP_INVOICES_B oklinv,
385: okl_txl_ap_inv_lns_all_b tpl,
386: okl_cnsld_ap_invs_all okl_cnsld,
404: AND ac.check_date <= v_end_date
405: UNION
406: SELECT oiv.datetime_valid change_date
407: FROM OKL_INDEX_VALUES oiv,
408: OKL_INDICES oi
409: WHERE oiv.idx_id = oi.id
410: AND oi.name = v_name
411: AND oiv.datetime_valid >= v_start_date
412: AND oiv.datetime_valid <= v_end_date;
446: CURSOR int_max_csr(v_name VARCHAR2,
447: v_interest_date DATE) IS
448: SELECT idv.value
449: FROM OKL_INDEX_VALUES idv,
450: OKL_INDICES idx
451: WHERE idx.ID = idv.IDX_ID
452: AND idx.NAME = v_name
453: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
454: FROM OKL_INDEX_VALUES idv ,
451: WHERE idx.ID = idv.IDX_ID
452: AND idx.NAME = v_name
453: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
454: FROM OKL_INDEX_VALUES idv ,
455: OKL_INDICES idx
456: WHERE idx.id = idv.idx_id
457: AND idx.name = v_name
458: AND idv.datetime_valid <= v_interest_date);
459:
475: CURSOR num_days_csr(p_date DATE) IS
476: SELECT add_months(trunc(p_date,'year'),12) - trunc(p_date,'year')
477: FROM dual;
478:
479: l_name OKL_INDICES.name%TYPE;
480: l_prev_start_date DATE;
481: l_temp_interest NUMBER := 0;
482: l_total_interest NUMBER := 0;
483: l_principal_amount NUMBER := 0;