APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_K_HEADERS

Line 949: okl_k_headers khr

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

Line 3332: l_chr_id okl_k_headers.id%TYPE;

3328: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3329: l_debug_enabled VARCHAR2(10);
3330: l_tradein_rec Okl_La_Tradein_Pvt.tradein_rec_type;
3331: x_tradein_rec Okl_La_Tradein_Pvt.tradein_rec_type;
3332: l_chr_id okl_k_headers.id%TYPE;
3333: l_ti_exists BOOLEAN := false;
3334:
3335: --cursor to fetch asset trade in adjustment details
3336: CURSOR get_asset_ti_details(p_ast_id IN okl_Assets_b.id%TYPE) IS

Line 4540: FROM okl_k_headers khr

4536: okl_lease_applications_b olav
4537: WHERE olav.leaseapp_template_id = olvv.ID -- lease app stores the template version id
4538: AND olav.ID = p_lap_id
4539: AND EXISTS (SELECT 1
4540: FROM okl_k_headers khr
4541: WHERE khr.ID = olvv.contract_template_id
4542: AND khr.template_type_code = 'CONTRACT') -- Consider only contract templates and not lease app contract templates
4543: ;
4544:

Line 5356: okl_k_headers khr

5352: , khr.ATTRIBUTE13, khr.ATTRIBUTE14, khr.ATTRIBUTE15
5353: FROM okl_leaseapp_templ_versions_b olvv,
5354: okl_lease_applications_b olav,
5355: okc_k_headers_v chr,
5356: okl_k_headers khr
5357: WHERE olav.leaseapp_template_id = olvv.ID -- lease app stores the template version id
5358: AND olav.ID = p_lap_id
5359: AND chr.id = khr.id
5360: AND chr.id = olvv.contract_template_id

Line 5362: FROM okl_k_headers khr

5358: AND olav.ID = p_lap_id
5359: AND chr.id = khr.id
5360: AND chr.id = olvv.contract_template_id
5361: AND EXISTS (SELECT 1
5362: FROM okl_k_headers khr
5363: WHERE khr.ID = olvv.contract_template_id
5364: AND khr.template_type_code = 'CONTRACT') -- Consider only contract templates and not lease app contract templates
5365: ;
5366: