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 OKL_K_HEADERS

Line 1030: from okl_k_headers

1026:
1027: -- Changes for multi gaap
1028: cursor multi_gaap_flag_cur IS
1029: select MULTI_GAAP_YN
1030: from okl_k_headers
1031: WHERE ID = l_ipyv_rec.khr_id ;
1032:
1033:
1034: cursor khr_product_cur IS

Line 1036: from okl_k_headers

1032:
1033:
1034: cursor khr_product_cur IS
1035: select PDT_ID
1036: from okl_k_headers
1037: WHERE ID = l_ipyv_rec.khr_id ;
1038: BEGIN
1039:
1040: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1494: from okl_k_headers

1490:
1491: -- Changes for multi gaap
1492: cursor multi_gaap_flag_cur IS
1493: select MULTI_GAAP_YN
1494: from okl_k_headers
1495: WHERE ID = p_khr_id ;
1496:
1497:
1498: cursor khr_product_cur IS

Line 1500: from okl_k_headers

1496:
1497:
1498: cursor khr_product_cur IS
1499: select PDT_ID
1500: from okl_k_headers
1501: WHERE ID = p_khr_id ;
1502:
1503:
1504: BEGIN

Line 2541: FROM OKL_K_HEADERS_V

2537: l_khr_id NUMBER := p_ipyv_rec.khr_id;
2538: l_dummy_var VARCHAR2(1) := '?';
2539: CURSOR okc_khr_csr IS
2540: SELECT 'x'
2541: FROM OKL_K_HEADERS_V
2542: WHERE OKL_K_HEADERS_V.ID = l_khr_id;
2543: BEGIN
2544: OPEN okc_khr_csr;
2545: FETCH okc_khr_csr INTO l_dummy_var ;

Line 2542: WHERE OKL_K_HEADERS_V.ID = l_khr_id;

2538: l_dummy_var VARCHAR2(1) := '?';
2539: CURSOR okc_khr_csr IS
2540: SELECT 'x'
2541: FROM OKL_K_HEADERS_V
2542: WHERE OKL_K_HEADERS_V.ID = l_khr_id;
2543: BEGIN
2544: OPEN okc_khr_csr;
2545: FETCH okc_khr_csr INTO l_dummy_var ;
2546: CLOSE okc_khr_csr ;

Line 4298: OKL_K_HEADERS KHR

4294: OKL_INS_CLASS_CATS OICC,
4295: OKL_K_LINES KLE ,
4296: OKL_K_LINES KLE_TOP ,
4297: OKC_K_LINES_B CLE ,
4298: OKL_K_HEADERS KHR
4299: WHERE KLE.ID = OTAB.KLE_ID
4300: AND KLE.ID = CLE.ID
4301: AND CLE.CLE_ID = KLE_TOP.ID
4302: AND TL.CATEGORY_ID = KLE_TOP.ITEM_INSURANCE_CATEGORY

Line 4378: OKL_K_HEADERS KHR ,

4374: OKC_LINE_STYLES_B LS,
4375: OKC_K_LINES_B ITEM_CLE,
4376: OKC_LINE_STYLES_B ITEM_LS,
4377: OKC_K_ITEMS MODEL ,
4378: OKL_K_HEADERS KHR ,
4379: OKC_K_LINES_B FINAN_CLE ,
4380: OKC_K_LINES_TL FINAN_CLET
4381: WHERE MODEL.cle_id = ITEM_CLE.ID
4382: AND MODEL.DNZ_CHR_ID = ITEM_CLE.DNZ_CHR_ID

Line 4504: OKL_K_HEADERS KHR

4500: FROM OKL_TXL_ASSETS_B OTAB,
4501: OKL_K_LINES KLE ,
4502: OKL_K_LINES KLE_TOP ,
4503: OKC_K_LINES_B CLE ,
4504: OKL_K_HEADERS KHR
4505: WHERE KLE.ID = OTAB.KLE_ID
4506: AND KLE.ID = CLE.ID
4507: AND CLE.CLE_ID = KLE_TOP.ID
4508: AND NOT EXISTS

Line 4560: OKL_K_HEADERS KHR ,

4556: OKC_LINE_STYLES_B LS,
4557: OKC_K_LINES_B ITEM_CLE,
4558: OKC_LINE_STYLES_B ITEM_LS,
4559: OKC_K_ITEMS MODEL ,
4560: OKL_K_HEADERS KHR ,
4561: OKC_K_LINES_B FINAN_CLE ,
4562: OKC_K_LINES_TL FINAN_CLET
4563: WHERE MODEL.cle_id = ITEM_CLE.ID
4564: AND MODEL.DNZ_CHR_ID = ITEM_CLE.DNZ_CHR_ID

Line 4653: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

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:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 4655: x_contract_currency okl_k_headers_full_v.currency_code%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:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4659: x_functional_covered_amt NUMBER ;

Line 4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

4652: ----- For Multi Currency
4653: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
4654:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4659: x_functional_covered_amt NUMBER ;
4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

4653: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
4654:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4659: x_functional_covered_amt NUMBER ;
4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
4661:

Line 4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

4654:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4659: x_functional_covered_amt NUMBER ;
4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
4661:
4662: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS

Line 4664: FROM okl_k_headers_full_v

4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
4661:
4662: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS
4663: SELECT currency_code , deal_type, AUTHORING_ORG_ID
4664: FROM okl_k_headers_full_v
4665: WHERE id = p_khr_id;
4666:
4667: l_fun_deal_amount NUMBER;
4668: l_fun_total_oec NUMBER;

Line 4669: l_authoring_org_id okl_k_headers_full_v.authoring_org_id%TYPE;

4665: WHERE id = p_khr_id;
4666:
4667: l_fun_deal_amount NUMBER;
4668: l_fun_total_oec NUMBER;
4669: l_authoring_org_id okl_k_headers_full_v.authoring_org_id%TYPE;
4670: --- for Organization
4671: l_inv_org_id NUMBER;
4672:
4673: --- Loan Contract

Line 5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

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:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

5371:
5372:
5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
5374:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5379: x_functional_covered_amt NUMBER ;

Line 5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

5372:
5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
5374:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5379: x_functional_covered_amt NUMBER ;
5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
5374:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5379: x_functional_covered_amt NUMBER ;
5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
5381:

Line 5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

5374:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5379: x_functional_covered_amt NUMBER ;
5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
5381:
5382: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS

Line 5384: FROM okl_k_headers_full_v

5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
5381:
5382: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS
5383: SELECT currency_code, start_date
5384: FROM okl_k_headers_full_v
5385: WHERE id = p_khr_id;
5386: x_func_calculated_premium NUMBER ;
5387: l_con_start_date DATE ;
5388:

Line 6836: OKL_K_HEADERS KHR

6832: FROM OKL_TXL_ASSETS_B OTAB,
6833: OKL_K_LINES KLE ,
6834: OKL_K_LINES KLE_TOP ,
6835: OKC_K_LINES_B CLE ,
6836: OKL_K_HEADERS KHR
6837: WHERE KLE.ID = OTAB.KLE_ID
6838: AND KLE.ID = CLE.ID
6839: AND CLE.CLE_ID = KLE_TOP.ID
6840: AND NOT EXISTS

Line 6892: OKL_K_HEADERS KHR ,

6888: OKC_LINE_STYLES_B LS,
6889: OKC_K_LINES_B ITEM_CLE,
6890: OKC_LINE_STYLES_B ITEM_LS,
6891: OKC_K_ITEMS MODEL ,
6892: OKL_K_HEADERS KHR ,
6893: OKC_K_LINES_B FINAN_CLE ,
6894: OKC_K_LINES_TL FINAN_CLET
6895: WHERE MODEL.cle_id = ITEM_CLE.ID
6896: AND MODEL.DNZ_CHR_ID = ITEM_CLE.DNZ_CHR_ID

Line 7750: okl_k_headers oklchr

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
7754: and (STL.START_DATE <= chr.start_date)

Line 7766: from okl_k_headers

7762: where id = p_quote_id;
7763:
7764: Cursor get_product_id(p_contract_id NUMBER) is
7765: Select pdt_id
7766: from okl_k_headers
7767: where id = p_contract_id;
7768:
7769: Cursor get_st_gen_template_set_name(p_pdt_id NUMBER) is
7770: Select st_gen_tmpt_set_name