DBA Data[Home] [Help]

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

1661: l_func_total_lessor_premium NUMBER;
1662:
1663: CURSOR c_con_start IS
1664: SELECT start_date
1665: FROM okc_k_headers_b
1666: WHERE id = p_ipyv_rec.KHR_ID ;
1667: l_start_date DATE;
1668:
1669:

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

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

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

2923: l_attribute_label ak_attributes_tl.attribute_label_long%TYPE := NULL; --3927315
2924:
2925: CURSOR c_con_start(c_khr_id NUMBER)IS
2926: SELECT START_DATE
2927: FROM okc_k_headers_b
2928: WHERE id = c_khr_id ;
2929: -- get lease premium
2930: CURSOR c_okl_ins_asset IS
2931: SELECT SUM(lessor_premium)

Line 3371: okc_k_headers_b chr

3367: select ct.object1_id1 id
3368: from okc_contacts ct,
3369: okc_contact_sources csrc,
3370: okc_k_party_roles_b pty,
3371: okc_k_headers_b chr
3372: where ct.cpl_id = pty.id
3373: and ct.cro_code = csrc.cro_code
3374: and ct.jtot_object1_code = csrc.jtot_object_code
3375: and ct.dnz_chr_id = chr.id

Line 3980: okc_k_headers_b chr

3976: select ct.object1_id1 id
3977: from okc_contacts ct,
3978: okc_contact_sources csrc,
3979: okc_k_party_roles_b pty,
3980: okc_k_headers_b chr
3981: where ct.cpl_id = pty.id
3982: and ct.cro_code = csrc.cro_code
3983: and ct.jtot_object1_code = csrc.jtot_object_code
3984: and ct.dnz_chr_id = chr.id

Line 5149: from OKC_K_HEADERS_B chr ,

5145: AND KHR.STS_CODE = OST.CODE ;
5146: -- Get start date and end date for rebook contract ---
5147: CURSOR okc_new_k_effdate_csr(p_khr_id IN NUMBER) IS
5148: select chr.start_date ,chr.end_date
5149: from OKC_K_HEADERS_B chr ,
5150: OKL_TRX_CONTRACTS TRX
5151: where chr.ORIG_SYSTEM_ID1 = p_khr_id
5152: and chr.ORIG_SYSTEM_SOURCE_CODE = 'OKL_REBOOK'
5153: and chr.orig_system_id1 = trx.khr_id

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,

Line 5731: From okc_k_headers_b

5727:
5728: -- Get contract number
5729: cursor get_chr_number(c_khr_id NUMBER) is
5730: select contract_number
5731: From okc_k_headers_b
5732: where id = c_khr_id;
5733:
5734: chk_claims_rec chk_claims%ROWTYPE;
5735:

Line 6009: okc_k_headers_b chr

6005: select ct.object1_id1 id
6006: from okc_contacts ct,
6007: okc_contact_sources csrc,
6008: okc_k_party_roles_b pty,
6009: okc_k_headers_b chr
6010: where ct.cpl_id = pty.id
6011: and ct.cro_code = csrc.cro_code
6012: and ct.jtot_object1_code = csrc.jtot_object_code
6013: and ct.dnz_chr_id = chr.id