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 OKL_K_HEADERS_FULL_V

Line 47: FROM OKL_K_HEADERS_FULL_V

43:
44: -- cursor to get scs_code
45: CURSOR scs_code_csr IS
46: SELECT scs_code
47: FROM OKL_K_HEADERS_FULL_V
48: WHERE id = p_khr_id;
49:
50: BEGIN
51: -- get scs_code

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

1647: and IPYB.territory_code = inr.ic_id
1648: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
1649:
1650:
1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

1649:
1650:
1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1657: x_functional_covered_amt NUMBER ;

Line 1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1650:
1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1657: x_functional_covered_amt NUMBER ;
1658: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1657: x_functional_covered_amt NUMBER ;
1658: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
1659:

Line 1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1657: x_functional_covered_amt NUMBER ;
1658: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
1659:
1660:

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

2956: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)
2957: and IPYB.territory_code = inr.ic_id
2958: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2959:
2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

2957: and IPYB.territory_code = inr.ic_id
2958: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2959:
2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2965: x_functional_covered_amt NUMBER ;

Line 2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

2958: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2959:
2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2965: x_functional_covered_amt NUMBER ;
2966: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

2959:
2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2965: x_functional_covered_amt NUMBER ;
2966: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
2967:

Line 2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2965: x_functional_covered_amt NUMBER ;
2966: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
2967:
2968: BEGIN

Line 3343: FROM okl_k_headers_full_v

3339: SELECT currency_code
3340: ,currency_conversion_type
3341: -- ,currency_conversion_rate
3342: ,currency_conversion_date
3343: FROM okl_k_headers_full_v
3344: WHERE id = p_ipyv_rec.khr_id ;
3345:
3346: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3347: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 3346: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

3342: ,currency_conversion_date
3343: FROM okl_k_headers_full_v
3344: WHERE id = p_ipyv_rec.khr_id ;
3345:
3346: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3347: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3348:
3349: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3350: SELECT khr.pdt_id pdt_id

Line 3347: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

3343: FROM okl_k_headers_full_v
3344: WHERE id = p_ipyv_rec.khr_id ;
3345:
3346: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3347: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3348:
3349: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3350: SELECT khr.pdt_id pdt_id
3351: FROM okl_k_headers_v khr

Line 3961: FROM okl_k_headers_full_v

3957: SELECT currency_code
3958: ,currency_conversion_type
3959: -- ,currency_conversion_rate
3960: ,currency_conversion_date
3961: FROM okl_k_headers_full_v
3962: WHERE id = p_ipyv_rec.khr_id ;
3963:
3964: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3965: SELECT khr.pdt_id pdt_id,

Line 4004: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

4000: --smoduga..Bug 4493213 fix..08-aug-2005..end
4001:
4002:
4003: l_ptid NUMBER;
4004: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4005: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4006: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
4007:
4008: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;

Line 4005: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

4001:
4002:
4003: l_ptid NUMBER;
4004: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4005: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4006: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
4007:
4008: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
4009: --l_acct_call_rec l_acc_dtls_csr%ROWTYPE;

Line 5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

5885: -- l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5886: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5888: */
5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5891: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
5892: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
5893:

Line 5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

5886: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5888: */
5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5891: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
5892: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
5893:
5894: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - Start

Line 5989: FROM okl_k_headers_full_v

5985: CURSOR l_contract_currency_csr IS
5986: SELECT currency_code
5987: ,currency_conversion_type
5988: ,currency_conversion_date
5989: FROM okl_k_headers_full_v
5990: WHERE id = p_ipyv_rec.khr_id ;
5991:
5992:
5993: