DBA Data[Home] [Help]

APPS.OKL_VAR_INT_CATCHUP_PVT dependencies on OKL_K_HEADERS

Line 21: FROM okl_k_headers

17: p_due_date IN DATE) RETURN payment_tbl_type IS
18:
19: CURSOR l_contract_csr(p_contract_id NUMBER) IS
20: SELECT (NVL(term_duration,0) * 30) term_days
21: FROM okl_k_headers
22: WHERE id = p_contract_id;
23:
24: CURSOR c_khr_params(cp_khr_id IN NUMBER) IS
25: select khr.start_date

Line 209: from okl_k_headers_full_v khr

205: select khr.date_last_interim_interest_cal date_last_interim_interest_cal
206: , NVL(rpm.catchup_start_date, khr.start_date) catchup_start_date
207: , NVL(rpm.catchup_frequency_code, 'MONTHLY') catchup_frequency_code
208: , NVL(khr.date_terminated, khr.end_date) end_date
209: from okl_k_headers_full_v khr
210: , okl_k_rate_params rpm
211: where khr.id = rpm.khr_id
212: and khr.id = cp_khr_id;
213: