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_INS_QUOTE_PVT dependencies on OKC_K_HEADERS_B

Line 365: FROM OKC_K_HEADERS_B

361:
362: CURSOR fetch_lease_app(c_lakhr_id IN NUMBER)
363: IS
364: SELECT ORIG_SYSTEM_ID1
365: FROM OKC_K_HEADERS_B
366: WHERE id = p_lakhr_id;
367:
368: CURSOR fetch_policy(c_lease_app_id IN NUMBER)
369: IS

Line 2934: FROM OKC_K_HEADERS_B

2930:
2931: -- Added for currency code
2932: CURSOR l_currency_code(p_khr_id NUMBER) IS
2933: SELECT CURRENCY_CODE
2934: FROM OKC_K_HEADERS_B
2935: WHERE ID = p_khr_id ;
2936:
2937:
2938: BEGIN

Line 4473: FROM OKC_K_HEADERS_B

4469: -- To get deal size in months
4470:
4471: CURSOR okl_k_deal_size_csr (p_khr_id NUMBER) IS
4472: SELECT MONTHS_BETWEEN(END_DATE,START_DATE), CONTRACT_NUMBER ----20-Jan-2005 Bug# 4056484 PAGARG removing rounding
4473: FROM OKC_K_HEADERS_B
4474: WHERE ID = p_khr_id ;
4475: -- To get sum of oec
4476: CURSOR okl_k_total_oec_csr (p_khr_id NUMBER) IS -- Bug 4105057
4477: SELECT SUM(OEC)

Line 4650: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE ;

4646: l_dummy_var VARCHAR(1) := '?' ;
4647: l_khr_st_date DATE;
4648: l_khr_end_date DATE;
4649: l_asset_number VARCHAR2(15);
4650: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE ;
4651:
4652: ----- For Multi Currency
4653: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
4654:

Line 5341: FROM OKC_K_HEADERS_B

5337:
5338: CURSOR okl_k_deal_size_csr (p_khr_id NUMBER) IS
5339: -- Bug# 4056484 PAGARG removing rounding
5340: SELECT MONTHS_BETWEEN(END_DATE,START_DATE), CONTRACT_NUMBER
5341: FROM OKC_K_HEADERS_B
5342: WHERE ID = p_khr_id ;
5343:
5344:
5345: CURSOR okl_ins_rate_csr(p_territory_code VARCHAR2,p_covered_amount NUMBER, p_ipt_id NUMBER , p_from_date DATE, p_freq_factor NUMBER, p_fact_val NUMBER) IS

Line 5370: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE ;

5366: l_total_oec NUMBER ;
5367: l_product NUMBER ;
5368: i NUMBER := 0 ;
5369: l_dummy_var VARCHAR(1) := '?' ;
5370: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE ;
5371:
5372:
5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
5374:

Line 5686: l_contract_id OKC_K_HEADERS_B.ID%TYPE;

5682: l_tot_durs NUMBER := 0;
5683: l_tot_premium NUMBER := 0;
5684:
5685: --bug:3967640
5686: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
5687: l_currency OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
5688: l_precision NUMBER:= 0;
5689:
5690: --Declaring cursor to get policy/quote premium,frequny info.

Line 5687: l_currency OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;

5683: l_tot_premium NUMBER := 0;
5684:
5685: --bug:3967640
5686: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
5687: l_currency OKC_K_HEADERS_B.CURRENCY_CODE%TYPE;
5688: l_precision NUMBER:= 0;
5689:
5690: --Declaring cursor to get policy/quote premium,frequny info.
5691: CURSOR c_pol_qte_dtl(c_id NUMBER) IS

Line 5699: FROM OKC_K_HEADERS_B

5695:
5696: --Get contract currency
5697: CURSOR c_contract_currency_csr(p_khr_id IN NUMBER) IS
5698: SELECT CURRENCY_CODE
5699: FROM OKC_K_HEADERS_B
5700: WHERE ID = p_khr_id;
5701:
5702: --Get contract currency Precision
5703: CURSOR c_currency_precision(p_currency_code VARCHAR2) IS

Line 6074: FROM OKC_K_HEADERS_B OKHB

6070: IS
6071: SELECT IPY.ID
6072: ,IPY.POLICY_NUMBER
6073: ,OKHB.CONTRACT_NUMBER
6074: FROM OKC_K_HEADERS_B OKHB
6075: ,OKL_INS_POLICIES_B IPY
6076: ,OKL_TRX_CONTRACTS CTRX
6077: ,OKC_STATUSES_B OSTS
6078: WHERE OKHB.ID = IPY.KHR_ID

Line 6094: FROM OKC_K_HEADERS_B OKHB

6090:
6091: SELECT IPY.ID
6092: ,IPY.POLICY_NUMBER
6093: ,OKHB.CONTRACT_NUMBER
6094: FROM OKC_K_HEADERS_B OKHB
6095: ,OKL_INS_POLICIES_B IPY
6096: ,OKL_IN_RAMOUNT_BC_V KLRA -- Bug 5897792
6097: WHERE KLRA.KLE_ID = IPY.KLE_ID
6098: AND OKHB.ID = IPY.KHR_ID -- smoduga fix for 4383565

Line 6327: from OKC_K_HEADERS_B

6323: END IF;
6324:
6325: IF ( UPPER(l_stmv_rec.active_yn)= 'Y' ) THEN
6326: SELECT contract_number INTO l_contract_number
6327: from OKC_K_HEADERS_B
6328: WHERE ID = p_ipyv_rec.khr_id;
6329: OKC_API.set_message(G_APP_NAME,
6330: G_STREAM_ALREADY_ACTIVE,'COL_NAME',l_contract_number);
6331:

Line 7749: okc_k_headers_b chr,

7745: where stream_type_purpose like 'INSURANCE%'
7746: AND stream_type_purpose NOT IN
7747: (select stl.primary_sty_purpose
7748: from OKL_STRM_TMPT_LINES_UV stl,
7749: okc_k_headers_b chr,
7750: okl_k_headers oklchr
7751: where stl.primary_sty_purpose like 'INSURANCE%'
7752: and stl.primary_yn = 'Y'
7753: and stl.pdt_id = oklchr.pdt_id