APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKC_K_HEADERS_B

Line 666: FROM okc_k_headers_b CHR,

662: p_bal_date DATE;
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:

Line 858: l_currency_code okc_k_headers_b.currency_code%type;

854: l_stub_start_date DATE;
855: l_stub_days NUMBER;
856: l_stub_amount NUMBER;
857: l_ret_val VARCHAR2(1);
858: l_currency_code okc_k_headers_b.currency_code%type;
859:
860: --get the line id for the repriced rent from supertrump
861: FUNCTION get_kle_id(p_trx_number IN NUMBER,
862: p_index_number IN NUMBER,

Line 1511: l_contract_number okc_k_headers_b.contract_number%type;

1507: l_adder_months NUMBER := 0;
1508: l_interest_rate_tbl OKL_VARIABLE_INTEREST_PVT.interest_rate_tbl_type;
1509: l_interest_rate_tbl_count NUMBER;
1510: l_interest_rate_tbl_index NUMBER;
1511: l_contract_number okc_k_headers_b.contract_number%type;
1512: l_principal_balance_tbl okl_variable_interest_pvt.principal_balance_tbl_typ;
1513: l_total_lending NUMBER;
1514:
1515: l_rent_date_start DATE;

Line 1590: FROM okc_k_headers_b okc

1586: , okl.deal_type deal_type
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

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