DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_K_HEADERS

Line 947: okl_k_headers khr

943: term_duration
944: INTO l_contract_end_date,
945: l_term
946: FROM okc_k_headers_b chr,
947: okl_k_headers khr
948: WHERE chr.id = p_chr_id
949: AND chr.id = khr.id;
950: SELECT DECODE(p_payment_frequency, 'A', 12, 'S', 6, 'Q', 3, 'M', 1)
951: INTO l_mpp

Line 3294: l_chr_id okl_k_headers.id%TYPE;

3290: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3291: l_debug_enabled VARCHAR2(10);
3292: l_tradein_rec Okl_La_Tradein_Pvt.tradein_rec_type;
3293: x_tradein_rec Okl_La_Tradein_Pvt.tradein_rec_type;
3294: l_chr_id okl_k_headers.id%TYPE;
3295: l_ti_exists BOOLEAN := false;
3296:
3297: --cursor to fetch asset trade in adjustment details
3298: CURSOR get_asset_ti_details(p_ast_id IN okl_Assets_b.id%TYPE) IS