APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKL_K_HEADERS

Line 667: okl_k_headers khr

663:
664: CURSOR c_khr_type (p_khr_id NUMBER) IS
665: SELECT khr.deal_type deal_type
666: FROM okc_k_headers_b CHR,
667: okl_k_headers khr
668: WHERE khr.id = CHR.id
669: AND khr.id = p_khr_id;
670:
671: c_khr_type_rec c_khr_type%ROWTYPE;

Line 811: FROM okl_k_headers_full_v

807:
808: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
809: SELECT NVL(date_last_interim_interest_cal, start_date) reamort_date
810: ,currency_code
811: FROM okl_k_headers_full_v
812: WHERE id = p_chr_id;
813:
814: -- 10367844: Modified Cursor to fetch Frequency of
815: -- Payment Levels of Rent/Principal Payment/Loan Payment of Assets only

Line 1496: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

1492: l_no_of_periods NUMBER;
1493: l_reamort_date DATE;
1494: chr_start_date DATE;
1495: lx_interest_rec OKL_VARIABLE_INTEREST_PVT.interest_rec;
1496: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
1497: l_msg_index_out NUMBER;
1498: l_term_duration NUMBER;
1499: l_tot_principal_amount NUMBER := 0;
1500: l_frequency okc_rules_b.object1_id1%type;

Line 1591: , okl_k_headers okl

1587: , ppm.quality_val interest_calculation_basis
1588: , okc.authoring_org_id
1589: , round(months_between(okc.end_date, okl.date_last_interim_interest_cal)) remaining_term_in_months
1590: FROM okc_k_headers_b okc
1591: , okl_k_headers okl
1592: , okl_prod_qlty_val_uv ppm
1593: WHERE okc.id = cp_khr_id
1594: AND okl.id = okc.id
1595: AND okl.pdt_id = ppm.pdt_id

Line 1601: FROM OKC_K_HEADERS_B K, OKL_K_HEADERS KHR

1597:
1598: CURSOR c_periods_cur(p_contract_id NUMBER, p_period_date DATE) IS
1599: SELECT (KHR.TERM_DURATION - round(months_between(nvl(p_period_date,K.START_DATE), K.START_DATE))) MTH,
1600: KHR.TERM_DURATION term_duration
1601: FROM OKC_K_HEADERS_B K, OKL_K_HEADERS KHR
1602: WHERE K.id = p_contract_id
1603: and K.id = KHR.id;
1604:
1605: -- 10367844: Modified Cursor to fetch Frequency of

Line 1631: FROM okl_k_headers_full_v

1627: AND INTEREST_CALC_END_DATE = (SELECT max(INTEREST_CALC_END_DATE) FROM okl_var_int_params WHERE khr_id = p_contract_id);
1628:
1629: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
1630: SELECT NVL(date_last_interim_interest_cal, start_date) reamort_date
1631: FROM okl_k_headers_full_v
1632: WHERE id = p_contract_id;
1633: -- End by prasjain bug# 6142095
1634: --start | 19-May-08 cklee fixed Bug 7043360 |
1635: l_line_id_buf okl_k_lines.id%type := -1;