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_SEEDED_FUNCTIONS_PVT dependencies on OKL_K_HEADERS

Line 3026: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3022: l_year NUMBER;
3023: l_contract_number VARCHAR2(2000);
3024:
3025: -- cursor to get the contract number
3026: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3027: SELECT contract_number
3028: FROM OKC_K_HEADERS_B
3029: WHERE id = p_ctr_id;
3030:

Line 3145: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3141: l_total_rate NUMBER;
3142: l_contract_number VARCHAR2(2000);
3143:
3144: -- cursor to get the contract number
3145: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3146: SELECT contract_number
3147: FROM OKC_K_HEADERS_B
3148: WHERE id = p_ctr_id;
3149:

Line 3528: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3524:
3525: -- cursor to get the contract number
3526: -- 02-Oct-2003. SGIYER. Added condition ste.stream_element_date >= p_date
3527: -- on product management's instructions.
3528: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3529: SELECT contract_number
3530: FROM OKL_K_HEADERS_FULL_V
3531: WHERE id = p_ctr_id;
3532:

Line 3530: FROM OKL_K_HEADERS_FULL_V

3526: -- 02-Oct-2003. SGIYER. Added condition ste.stream_element_date >= p_date
3527: -- on product management's instructions.
3528: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3529: SELECT contract_number
3530: FROM OKL_K_HEADERS_FULL_V
3531: WHERE id = p_ctr_id;
3532:
3533: -- SGIYER
3534: -- modifying cursor for user defind streams project

Line 3648: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3644: l_lease_inc_sty_id NUMBER;
3645: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3646:
3647: -- cursor to get the contract number
3648: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3649: SELECT contract_number
3650: FROM OKL_K_HEADERS_FULL_V
3651: WHERE id = p_ctr_id;
3652:

Line 3650: FROM OKL_K_HEADERS_FULL_V

3646:
3647: -- cursor to get the contract number
3648: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3649: SELECT contract_number
3650: FROM OKL_K_HEADERS_FULL_V
3651: WHERE id = p_ctr_id;
3652:
3653: -- changing stream type name from INCOME to PRE TAX INCOME as suggested by PM. BUG# 2671223
3654: -- correcting name. Its hould be PRE-TAX INCOME (with hyphen)

Line 3807: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3803: l_unguaranteed_residual NUMBER := 0;
3804: l_contract_number VARCHAR2(2000);
3805:
3806: -- cursor to get the contract number
3807: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3808: SELECT contract_number
3809: FROM OKL_K_HEADERS_FULL_V
3810: WHERE id = p_ctr_id;
3811:

Line 3809: FROM OKL_K_HEADERS_FULL_V

3805:
3806: -- cursor to get the contract number
3807: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3808: SELECT contract_number
3809: FROM OKL_K_HEADERS_FULL_V
3810: WHERE id = p_ctr_id;
3811:
3812: CURSOR get_ung_res_csr(p_ctr_id NUMBER) IS
3813: SELECT SUM(NVL(RESIDUAL_VALUE,0)) - SUM(NVL(RESIDUAL_GRNTY_AMOUNT, 0))

Line 3884: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3880: l_subsidy_inc_id NUMBER;
3881: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3882:
3883: -- cursor to get the contract number
3884: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3885: SELECT contract_number
3886: FROM OKL_K_HEADERS_FULL_V
3887: WHERE id = p_ctr_id;
3888:

Line 3886: FROM OKL_K_HEADERS_FULL_V

3882:
3883: -- cursor to get the contract number
3884: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3885: SELECT contract_number
3886: FROM OKL_K_HEADERS_FULL_V
3887: WHERE id = p_ctr_id;
3888:
3889: -- cursor to get unaccrued subsidy for a contract
3890: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS

Line 3890: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS

3886: FROM OKL_K_HEADERS_FULL_V
3887: WHERE id = p_ctr_id;
3888:
3889: -- cursor to get unaccrued subsidy for a contract
3890: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS
3891: SELECT SUM(ste.amount)
3892: FROM OKL_STRM_ELEMENTS ste,
3893: OKL_STRM_TYPE_B sty,
3894: OKL_STREAMS stm

Line 4079: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

4075: l_sty_id NUMBER;
4076: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4077:
4078: -- cursor to get the contract number
4079: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4080: SELECT contract_number
4081: FROM OKL_K_HEADERS_FULL_V
4082: WHERE id = p_ctr_id;
4083:

Line 4081: FROM OKL_K_HEADERS_FULL_V

4077:
4078: -- cursor to get the contract number
4079: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4080: SELECT contract_number
4081: FROM OKL_K_HEADERS_FULL_V
4082: WHERE id = p_ctr_id;
4083:
4084: -- cursor to get unaccrued subsidy for a contract
4085: CURSOR total_accrued_csr(p_ctr_id NUMBER, p_date DATE, p_sty_id NUMBER) IS

Line 5078: FROM okc_k_headers_b a, okl_k_headers b

5074:
5075: -- Get the financial product of the contract
5076: CURSOR l_get_fin_product(cp_khr_id IN NUMBER) IS
5077: SELECT a.start_date, a.contract_number, b.pdt_id
5078: FROM okc_k_headers_b a, okl_k_headers b
5079: WHERE a.id = b.id
5080: AND a.id = cp_khr_id;
5081:
5082: SUBTYPE pdtv_rec_type IS OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;

5766: l_depn_contract NUMBER := 0;
5767: l_converted_amount NUMBER := 0;
5768: p_return_status VARCHAR2(1);
5769: p_contract_start_date DATE;
5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5774:

Line 5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

5767: l_converted_amount NUMBER := 0;
5768: p_return_status VARCHAR2(1);
5769: p_contract_start_date DATE;
5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5774:
5775: --Cursor to get the parent line id for a contract

Line 5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

5768: p_return_status VARCHAR2(1);
5769: p_contract_start_date DATE;
5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5774:
5775: --Cursor to get the parent line id for a contract
5776: CURSOR parent_line_id_csr (p_contract_id NUMBER)

Line 5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

5769: p_contract_start_date DATE;
5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5774:
5775: --Cursor to get the parent line id for a contract
5776: CURSOR parent_line_id_csr (p_contract_id NUMBER)
5777: IS

Line 6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;

6396: l_depn_contract NUMBER := 0;
6397: l_converted_amount NUMBER := 0;
6398: p_return_status VARCHAR2(1);
6399: p_contract_start_date DATE;
6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6404:

Line 6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

6397: l_converted_amount NUMBER := 0;
6398: p_return_status VARCHAR2(1);
6399: p_contract_start_date DATE;
6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6404:
6405: --Cursor to get the parent line id for a contract

Line 6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

6398: p_return_status VARCHAR2(1);
6399: p_contract_start_date DATE;
6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6404:
6405: --Cursor to get the parent line id for a contract
6406: CURSOR parent_line_id_csr (p_contract_id NUMBER)

Line 6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

6399: p_contract_start_date DATE;
6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6404:
6405: --Cursor to get the parent line id for a contract
6406: CURSOR parent_line_id_csr (p_contract_id NUMBER)
6407: IS

Line 6650: FROM okl_k_headers

6646:
6647: CURSOR contract_rate_csr (c_contract_id NUMBER)
6648: IS
6649: SELECT implicit_interest_rate
6650: FROM okl_k_headers
6651: WHERE id=c_contract_id;
6652:
6653:
6654: CURSOR k_curr_code (c_contract_id NUMBER)

Line 8321: l_program_id okl_k_headers.khr_id%TYPE;

8317: l_return_Status VARCHAR2(1):=FND_Api.G_RET_STS_SUCCESS;
8318: l_id1 VARCHAR2(40);
8319: l_id2 VARCHAR2(200);
8320: l_days_allowed NUMBER :=0;
8321: l_program_id okl_k_headers.khr_id%TYPE;
8322: l_delinquent_amount NUMBER :=0;
8323:
8324:
8325: BEGIN

Line 8331: FROM okl_k_headers

8327: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
8328: END IF;
8329:
8330: SELECT khr_id INTO l_program_id
8331: FROM okl_k_headers
8332: WHERE id=p_contract_id;
8333:
8334:
8335: l_return_status := okl_contract_info.get_rule_value(

Line 10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

10791: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
10792:
10793: l_converted_amount NUMBER;
10794: l_contract_start_date DATE;
10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
10799:

Line 10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

10792:
10793: l_converted_amount NUMBER;
10794: l_contract_start_date DATE;
10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
10799:
10800: -- Bug# 4061058:

Line 10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

10793: l_converted_amount NUMBER;
10794: l_contract_start_date DATE;
10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
10799:
10800: -- Bug# 4061058:
10801: -- Changes to ensure that the query works for Release Asset

Line 10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

10794: l_contract_start_date DATE;
10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
10799:
10800: -- Bug# 4061058:
10801: -- Changes to ensure that the query works for Release Asset
10802: -- and Release Contract

Line 11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

11014: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11015:
11016: l_converted_amount NUMBER;
11017: l_contract_start_date DATE;
11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11022:

Line 11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

11015:
11016: l_converted_amount NUMBER;
11017: l_contract_start_date DATE;
11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11022:
11023: -- Bug# 4061058:

Line 11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

11016: l_converted_amount NUMBER;
11017: l_contract_start_date DATE;
11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11022:
11023: -- Bug# 4061058:
11024: -- Changes to ensure that the query works for Release Asset

Line 11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

11017: l_contract_start_date DATE;
11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11022:
11023: -- Bug# 4061058:
11024: -- Changes to ensure that the query works for Release Asset
11025: -- and Release Contract

Line 11595: FROM OKL_K_HEADERS chr

11591:
11592: --cursor to find...
11593: Cursor l_csr( ChrId NUMBER) IS
11594: SELECT NVL(chr.TOT_CL_TRANSFER_AMT,0)
11595: FROM OKL_K_HEADERS chr
11596: WHERE chr.ID = ChrId;
11597:
11598: l_amount number := 0;
11599:

Line 11652: FROM OKL_K_HEADERS chr

11648:
11649: --cursor to find...
11650: Cursor l_csr( ChrId NUMBER) IS
11651: SELECT NVL(chr.TOT_CL_NET_TRANSFER_AMT,0)
11652: FROM OKL_K_HEADERS chr
11653: WHERE chr.ID = ChrId;
11654:
11655: l_amount number := 0;
11656:

Line 13159: FROM OKL_K_HEADERS

13155:
13156: --SECHAWLA 30-NOV-05 4753429 : New declarations begin
13157: CURSOR l_dealtype_csr (cp_khr_id IN NUMBER) IS
13158: SELECT deal_type
13159: FROM OKL_K_HEADERS
13160: WHERE id = cp_khr_id;
13161:
13162: l_deal_type VARCHAR2(30);
13163: --SECHAWLA 30-NOV-05 4753429 : New declarations end

Line 13851: FROM okl_k_headers

13847: RETURN VARCHAR2 IS
13848:
13849: CURSOR c_k_vendor_prog_info IS
13850: SELECT khr_id
13851: FROM okl_k_headers
13852: WHERE id = p_contract_id;
13853:
13854: CURSOR c_lap_vendor_prog_info(p_lease_app_id IN NUMBER) IS
13855: SELECT program_agreement_id

Line 14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

14013: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
14014:
14015: l_converted_amount NUMBER;
14016: l_contract_start_date DATE;
14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
14021:

Line 14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

14014:
14015: l_converted_amount NUMBER;
14016: l_contract_start_date DATE;
14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
14021:
14022: CURSOR l_asset_csr(p_chr_id IN NUMBER

Line 14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

14015: l_converted_amount NUMBER;
14016: l_contract_start_date DATE;
14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
14021:
14022: CURSOR l_asset_csr(p_chr_id IN NUMBER
14023: ,p_cle_id IN NUMBER

Line 14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

14016: l_contract_start_date DATE;
14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
14021:
14022: CURSOR l_asset_csr(p_chr_id IN NUMBER
14023: ,p_cle_id IN NUMBER
14024: ,p_book_class IN VARCHAR2 -- 7626121