APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_K_HEADERS_BH

Line 2554: FROM OKC_K_HEADERS_BH

2550: x_cancel_flag VARCHAR2(1) := 'N';
2551: --ger Max version
2552: CURSOR c_get_chr_version(cp_chr_id NUMBER) IS
2553: SELECT MAX(major_version)
2554: FROM OKC_K_HEADERS_BH
2555: WHERE id = cp_chr_id;
2556: --- Check for addition of the fixed asset line
2557: -- gboomina Bug 5015042 - Start
2558: -- Changing where condition to handle more than one asset

Line 2649: OKC_K_HEADERS_BH H_CHR

2645: SELECT c_chr.START_DATE c_start_date,h_chr.START_DATE h_start_date,
2646: round (months_between(c_chr.end_date,c_chr.START_DATE)) c_term,
2647: round (months_between(h_chr.end_date,h_chr.START_DATE)) h_term
2648: FROM OKC_K_HEADERS_B C_CHR,
2649: OKC_K_HEADERS_BH H_CHR
2650: WHERE c_chr.id = h_chr.id
2651: AND h_chr.major_version = cp_version
2652: AND c_chr.id = cp_chr_id
2653: AND ROWNUM = 1;

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

5163: and trx.tsu_code <> 'PROCESSED'
5164: and trx.representation_type = 'PRIMARY'; -- MGAAP 7263041
5165: --Get Major_version of the original contract in case of rebook---
5166: CURSOR okc_maj_ver_csr(p_khr_id IN NUMBER) IS
5167: select max(major_version) from okc_k_headers_bh where ID =p_khr_id ;
5168: -- Get Orginal contract dates from contract history before doing rebook
5169: CURSOR okc_old_k_effdate_csr(p_khr_id IN NUMBER,l_maj_ver_num IN NUMBER) IS
5170: select start_date ,end_date
5171: From okc_k_headers_bh

Line 5171: From okc_k_headers_bh

5167: select max(major_version) from okc_k_headers_bh where ID =p_khr_id ;
5168: -- Get Orginal contract dates from contract history before doing rebook
5169: CURSOR okc_old_k_effdate_csr(p_khr_id IN NUMBER,l_maj_ver_num IN NUMBER) IS
5170: select start_date ,end_date
5171: From okc_k_headers_bh
5172: where ID = p_khr_id
5173: And major_version = l_maj_ver_num;
5174: PROCEDURE migrate (
5175: p_from IN ipyv_rec_type,