APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_K_HEADERS_BH

Line 2573: FROM OKC_K_HEADERS_BH

2569: x_cancel_flag VARCHAR2(1) := 'N';
2570: --ger Max version
2571: CURSOR c_get_chr_version(cp_chr_id NUMBER) IS
2572: SELECT MAX(major_version)
2573: FROM OKC_K_HEADERS_BH
2574: WHERE id = cp_chr_id;
2575: --- Check for addition of the fixed asset line
2576: -- gboomina Bug 5015042 - Start
2577: -- Changing where condition to handle more than one asset

Line 2668: OKC_K_HEADERS_BH H_CHR

2664: SELECT c_chr.START_DATE c_start_date,h_chr.START_DATE h_start_date,
2665: round (months_between(c_chr.end_date,c_chr.START_DATE)) c_term,
2666: round (months_between(h_chr.end_date,h_chr.START_DATE)) h_term
2667: FROM OKC_K_HEADERS_B C_CHR,
2668: OKC_K_HEADERS_BH H_CHR
2669: WHERE c_chr.id = h_chr.id
2670: AND h_chr.major_version = cp_version
2671: AND c_chr.id = cp_chr_id
2672: AND ROWNUM = 1;

Line 5160: select max(major_version) from okc_k_headers_bh where ID =p_khr_id ;

5156: and trx.tsu_code <> 'PROCESSED'
5157: and trx.representation_type = 'PRIMARY'; -- MGAAP 7263041
5158: --Get Major_version of the original contract in case of rebook---
5159: CURSOR okc_maj_ver_csr(p_khr_id IN NUMBER) IS
5160: select max(major_version) from okc_k_headers_bh where ID =p_khr_id ;
5161: -- Get Orginal contract dates from contract history before doing rebook
5162: CURSOR okc_old_k_effdate_csr(p_khr_id IN NUMBER,l_maj_ver_num IN NUMBER) IS
5163: select start_date ,end_date
5164: From okc_k_headers_bh

Line 5164: From okc_k_headers_bh

5160: select max(major_version) from okc_k_headers_bh where ID =p_khr_id ;
5161: -- Get Orginal contract dates from contract history before doing rebook
5162: CURSOR okc_old_k_effdate_csr(p_khr_id IN NUMBER,l_maj_ver_num IN NUMBER) IS
5163: select start_date ,end_date
5164: From okc_k_headers_bh
5165: where ID = p_khr_id
5166: And major_version = l_maj_ver_num;
5167: PROCEDURE migrate (
5168: p_from IN ipyv_rec_type,