eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_K_HEADERS_B

Line 486: FROM OKC_K_HEADERS_B

482: WHERE ID = P_TAP_ID ;
483:
484: CURSOR C_CURRENCY (P_khr_ID NUMBER) IS
485: SELECT CURRENCY_CODE --Bug:3825159
486: FROM OKC_K_HEADERS_B
487: WHERE ID = P_khr_ID ;
488:
489:
490: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;

Line 780: OKC_K_HEADERS_B CHR,

776:
777: CURSOR c_vendor_info (p_kle_id NUMBER ) IS --bug 4146178
778: SELECT PV.VENDOR_ID VENDOR_ID,PV.VENDOR_NAME VENDOR_NAME,CHR.AUTHORING_ORG_ID ORG_ID
779: FROM OKL_INS_POLICIES_B IPYB ,
780: OKC_K_HEADERS_B CHR,
781: PO_VENDORS PV
782: WHERE IPYB.KLE_ID = p_kle_id
783: AND CHR.ID = IPYB.KHR_ID
784: AND IPYB.ISU_ID = PV.VENDOR_ID;

Line 809: FROM OKC_K_HEADERS_B -- Changed to table

805: WHERE ID = P_TAP_ID ;
806:
807: CURSOR C_CURRENCY (P_khr_ID NUMBER) IS
808: SELECT CURRENCY_CODE
809: FROM OKC_K_HEADERS_B -- Changed to table
810: WHERE ID = P_khr_ID ;
811:
812:
813: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;

Line 1646: FROM okc_k_headers_b

1642: l_func_total_lessor_premium NUMBER;
1643:
1644: CURSOR c_con_start IS
1645: SELECT start_date
1646: FROM okc_k_headers_b
1647: WHERE id = p_ipyv_rec.KHR_ID ;
1648: l_start_date DATE;
1649:
1650:

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 2648: FROM OKC_K_HEADERS_B C_CHR,

2644: CURSOR c_get_chr_start_end_date(cp_version NUMBER,cp_chr_id NUMBER) IS
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

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 2908: FROM okc_k_headers_b

2904: l_attribute_label ak_attributes_tl.attribute_label_long%TYPE := NULL; --3927315
2905:
2906: CURSOR c_con_start(c_khr_id NUMBER)IS
2907: SELECT START_DATE
2908: FROM okc_k_headers_b
2909: WHERE id = c_khr_id ;
2910: -- get lease premium
2911: CURSOR c_okl_ins_asset IS
2912: SELECT SUM(lessor_premium)

Line 3352: okc_k_headers_b chr

3348: select ct.object1_id1 id
3349: from okc_contacts ct,
3350: okc_contact_sources csrc,
3351: okc_k_party_roles_b pty,
3352: okc_k_headers_b chr
3353: where ct.cpl_id = pty.id
3354: and ct.cro_code = csrc.cro_code
3355: and ct.jtot_object1_code = csrc.jtot_object_code
3356: and ct.dnz_chr_id = chr.id

Line 3955: okc_k_headers_b chr

3951: select ct.object1_id1 id
3952: from okc_contacts ct,
3953: okc_contact_sources csrc,
3954: okc_k_party_roles_b pty,
3955: okc_k_headers_b chr
3956: where ct.cpl_id = pty.id
3957: and ct.cro_code = csrc.cro_code
3958: and ct.jtot_object1_code = csrc.jtot_object_code
3959: and ct.dnz_chr_id = chr.id

Line 5156: from OKC_K_HEADERS_B chr ,

5152: AND KHR.STS_CODE = OST.CODE ;
5153: -- Get start date and end date for rebook contract ---
5154: CURSOR okc_new_k_effdate_csr(p_khr_id IN NUMBER) IS
5155: select chr.start_date ,chr.end_date
5156: from OKC_K_HEADERS_B chr ,
5157: OKL_TRX_CONTRACTS TRX
5158: where chr.ORIG_SYSTEM_ID1 = p_khr_id
5159: and chr.ORIG_SYSTEM_SOURCE_CODE = 'OKL_REBOOK'
5160: and chr.orig_system_id1 = trx.khr_id

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,

Line 5738: From okc_k_headers_b

5734:
5735: -- Get contract number
5736: cursor get_chr_number(c_khr_id NUMBER) is
5737: select contract_number
5738: From okc_k_headers_b
5739: where id = c_khr_id;
5740:
5741: chk_claims_rec chk_claims%ROWTYPE;
5742:

Line 6016: okc_k_headers_b chr

6012: select ct.object1_id1 id
6013: from okc_contacts ct,
6014: okc_contact_sources csrc,
6015: okc_k_party_roles_b pty,
6016: okc_k_headers_b chr
6017: where ct.cpl_id = pty.id
6018: and ct.cro_code = csrc.cro_code
6019: and ct.jtot_object1_code = csrc.jtot_object_code
6020: and ct.dnz_chr_id = chr.id