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 3490: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3486: l_year NUMBER;
3487: l_contract_number VARCHAR2(2000);
3488:
3489: -- cursor to get the contract number
3490: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3491: SELECT contract_number
3492: FROM OKC_K_HEADERS_B
3493: WHERE id = p_ctr_id;
3494:

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

3605: l_total_rate NUMBER;
3606: l_contract_number VARCHAR2(2000);
3607:
3608: -- cursor to get the contract number
3609: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3610: SELECT contract_number
3611: FROM OKC_K_HEADERS_B
3612: WHERE id = p_ctr_id;
3613:

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

3995:
3996: -- cursor to get the contract number
3997: -- 02-Oct-2003. SGIYER. Added condition ste.stream_element_date >= p_date
3998: -- on product management's instructions.
3999: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4000: SELECT contract_number
4001: FROM OKL_K_HEADERS_FULL_V
4002: WHERE id = p_ctr_id;
4003:

Line 4001: FROM OKL_K_HEADERS_FULL_V

3997: -- 02-Oct-2003. SGIYER. Added condition ste.stream_element_date >= p_date
3998: -- on product management's instructions.
3999: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4000: SELECT contract_number
4001: FROM OKL_K_HEADERS_FULL_V
4002: WHERE id = p_ctr_id;
4003:
4004: -- SGIYER
4005: -- modifying cursor for user defind streams project

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

4115: l_lease_inc_sty_id NUMBER;
4116: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4117:
4118: -- cursor to get the contract number
4119: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4120: SELECT contract_number
4121: FROM OKL_K_HEADERS_FULL_V
4122: WHERE id = p_ctr_id;
4123:

Line 4121: FROM OKL_K_HEADERS_FULL_V

4117:
4118: -- cursor to get the contract number
4119: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4120: SELECT contract_number
4121: FROM OKL_K_HEADERS_FULL_V
4122: WHERE id = p_ctr_id;
4123:
4124: -- changing stream type name from INCOME to PRE TAX INCOME as suggested by PM. BUG# 2671223
4125: -- correcting name. Its hould be PRE-TAX INCOME (with hyphen)

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

4366: l_unguaranteed_residual NUMBER := 0;
4367: l_contract_number VARCHAR2(2000);
4368:
4369: -- cursor to get the contract number
4370: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4371: SELECT contract_number
4372: FROM OKL_K_HEADERS_FULL_V
4373: WHERE id = p_ctr_id;
4374:

Line 4372: FROM OKL_K_HEADERS_FULL_V

4368:
4369: -- cursor to get the contract number
4370: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4371: SELECT contract_number
4372: FROM OKL_K_HEADERS_FULL_V
4373: WHERE id = p_ctr_id;
4374:
4375: CURSOR get_ung_res_csr(p_ctr_id NUMBER) IS
4376: SELECT SUM(NVL(RESIDUAL_VALUE,0)) - SUM(NVL(RESIDUAL_GRNTY_AMOUNT, 0))

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

4443: l_subsidy_inc_id NUMBER;
4444: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4445:
4446: -- cursor to get the contract number
4447: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4448: SELECT contract_number
4449: FROM OKL_K_HEADERS_FULL_V
4450: WHERE id = p_ctr_id;
4451:

Line 4449: FROM OKL_K_HEADERS_FULL_V

4445:
4446: -- cursor to get the contract number
4447: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4448: SELECT contract_number
4449: FROM OKL_K_HEADERS_FULL_V
4450: WHERE id = p_ctr_id;
4451:
4452: -- cursor to get unaccrued subsidy for a contract
4453: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS

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

4449: FROM OKL_K_HEADERS_FULL_V
4450: WHERE id = p_ctr_id;
4451:
4452: -- cursor to get unaccrued subsidy for a contract
4453: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS
4454: SELECT SUM(ste.amount)
4455: FROM OKL_STRM_ELEMENTS ste,
4456: OKL_STRM_TYPE_B sty,
4457: OKL_STREAMS stm

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

4638: l_sty_id NUMBER;
4639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4640:
4641: -- cursor to get the contract number
4642: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4643: SELECT contract_number
4644: FROM OKL_K_HEADERS_FULL_V
4645: WHERE id = p_ctr_id;
4646:

Line 4644: FROM OKL_K_HEADERS_FULL_V

4640:
4641: -- cursor to get the contract number
4642: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4643: SELECT contract_number
4644: FROM OKL_K_HEADERS_FULL_V
4645: WHERE id = p_ctr_id;
4646:
4647:
4648: -- cursor to get unaccrued subsidy for a contract

Line 5676: FROM okc_k_headers_b a, okl_k_headers b

5672:
5673: -- Get the financial product of the contract
5674: CURSOR l_get_fin_product(cp_khr_id IN NUMBER) IS
5675: SELECT a.start_date, a.contract_number, b.pdt_id
5676: FROM okc_k_headers_b a, okl_k_headers b
5677: WHERE a.id = b.id
5678: AND a.id = cp_khr_id;
5679:
5680: SUBTYPE pdtv_rec_type IS OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;

6364: l_depn_contract NUMBER := 0;
6365: l_converted_amount NUMBER := 0;
6366: p_return_status VARCHAR2(1);
6367: p_contract_start_date DATE;
6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6372:

Line 6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

6365: l_converted_amount NUMBER := 0;
6366: p_return_status VARCHAR2(1);
6367: p_contract_start_date DATE;
6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6372:
6373: --Cursor to get the parent line id for a contract

Line 6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

6366: p_return_status VARCHAR2(1);
6367: p_contract_start_date DATE;
6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6372:
6373: --Cursor to get the parent line id for a contract
6374: CURSOR parent_line_id_csr (p_contract_id NUMBER)

Line 6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

6367: p_contract_start_date DATE;
6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6372:
6373: --Cursor to get the parent line id for a contract
6374: CURSOR parent_line_id_csr (p_contract_id NUMBER)
6375: IS

Line 6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;

6994: l_depn_contract NUMBER := 0;
6995: l_converted_amount NUMBER := 0;
6996: p_return_status VARCHAR2(1);
6997: p_contract_start_date DATE;
6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
7002:

Line 6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

6995: l_converted_amount NUMBER := 0;
6996: p_return_status VARCHAR2(1);
6997: p_contract_start_date DATE;
6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
7002:
7003: --Cursor to get the parent line id for a contract

Line 7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

6996: p_return_status VARCHAR2(1);
6997: p_contract_start_date DATE;
6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
7002:
7003: --Cursor to get the parent line id for a contract
7004: CURSOR parent_line_id_csr (p_contract_id NUMBER)

Line 7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

6997: p_contract_start_date DATE;
6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
7002:
7003: --Cursor to get the parent line id for a contract
7004: CURSOR parent_line_id_csr (p_contract_id NUMBER)
7005: IS

Line 7248: FROM okl_k_headers

7244:
7245: CURSOR contract_rate_csr (c_contract_id NUMBER)
7246: IS
7247: SELECT implicit_interest_rate
7248: FROM okl_k_headers
7249: WHERE id=c_contract_id;
7250:
7251:
7252: CURSOR k_curr_code (c_contract_id NUMBER)

Line 8995: l_program_id okl_k_headers.khr_id%TYPE;

8991: l_return_Status VARCHAR2(1):=FND_Api.G_RET_STS_SUCCESS;
8992: l_id1 VARCHAR2(40);
8993: l_id2 VARCHAR2(200);
8994: l_days_allowed NUMBER :=0;
8995: l_program_id okl_k_headers.khr_id%TYPE;
8996: l_delinquent_amount NUMBER :=0;
8997:
8998:
8999: BEGIN

Line 9005: FROM okl_k_headers

9001: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
9002: END IF;
9003:
9004: SELECT khr_id INTO l_program_id
9005: FROM okl_k_headers
9006: WHERE id=p_contract_id;
9007:
9008:
9009: l_return_status := okl_contract_info.get_rule_value(

Line 11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

11742: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11743:
11744: l_converted_amount NUMBER;
11745: l_contract_start_date DATE;
11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11750:

Line 11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

11743:
11744: l_converted_amount NUMBER;
11745: l_contract_start_date DATE;
11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11750:
11751: -- Bug# 4061058:

Line 11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

11744: l_converted_amount NUMBER;
11745: l_contract_start_date DATE;
11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11750:
11751: -- Bug# 4061058:
11752: -- Changes to ensure that the query works for Release Asset

Line 11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

11745: l_contract_start_date DATE;
11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11750:
11751: -- Bug# 4061058:
11752: -- Changes to ensure that the query works for Release Asset
11753: -- and Release Contract

Line 12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

12102: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12103:
12104: l_converted_amount NUMBER;
12105: l_contract_start_date DATE;
12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12110:

Line 12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

12103:
12104: l_converted_amount NUMBER;
12105: l_contract_start_date DATE;
12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12110:
12111: -- Bug# 4061058:

Line 12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

12104: l_converted_amount NUMBER;
12105: l_contract_start_date DATE;
12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12110:
12111: -- Bug# 4061058:
12112: -- Changes to ensure that the query works for Release Asset

Line 12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

12105: l_contract_start_date DATE;
12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12110:
12111: -- Bug# 4061058:
12112: -- Changes to ensure that the query works for Release Asset
12113: -- and Release Contract

Line 12683: FROM OKL_K_HEADERS chr

12679:
12680: --cursor to find...
12681: Cursor l_csr( ChrId NUMBER) IS
12682: SELECT NVL(chr.TOT_CL_TRANSFER_AMT,0)
12683: FROM OKL_K_HEADERS chr
12684: WHERE chr.ID = ChrId;
12685:
12686: l_amount number := 0;
12687:

Line 12740: FROM OKL_K_HEADERS chr

12736:
12737: --cursor to find...
12738: Cursor l_csr( ChrId NUMBER) IS
12739: SELECT NVL(chr.TOT_CL_NET_TRANSFER_AMT,0)
12740: FROM OKL_K_HEADERS chr
12741: WHERE chr.ID = ChrId;
12742:
12743: l_amount number := 0;
12744:

Line 12901: FROM okl_k_headers khr,

12897: --Bug 10075141
12898: CURSOR get_pricing_det_csr(p_khr_id IN NUMBER) IS
12899: SELECT gts.pricing_engine,
12900: gts.isg_arrears_pay_dates_option
12901: FROM okl_k_headers khr,
12902: okl_products pdt,
12903: okl_ae_tmpt_sets_all aes,
12904: okl_st_gen_tmpt_sets_all gts
12905: WHERE khr.pdt_id = pdt.id

Line 12930: okl_k_headers khr

12926: CURSOR get_pricing_name_csr (p_sty_id IN NUMBER, p_khr_id NUMBER) IS
12927: SELECT pricing_name
12928: FROM okl_strm_tmpt_lines_uv stl,
12929: okc_k_headers_b chr,
12930: okl_k_headers khr
12931: WHERE chr.id = p_khr_id
12932: AND khr.id = chr.id
12933: AND stl.primary_yn = 'Y'
12934: AND stl.pdt_id = khr.pdt_id

Line 14391: FROM OKL_K_HEADERS

14387:
14388: --SECHAWLA 30-NOV-05 4753429 : New declarations begin
14389: CURSOR l_dealtype_csr (cp_khr_id IN NUMBER) IS
14390: SELECT deal_type
14391: FROM OKL_K_HEADERS
14392: WHERE id = cp_khr_id;
14393:
14394: l_deal_type VARCHAR2(30);
14395: --SECHAWLA 30-NOV-05 4753429 : New declarations end

Line 15083: FROM okl_k_headers

15079: RETURN VARCHAR2 IS
15080:
15081: CURSOR c_k_vendor_prog_info IS
15082: SELECT khr_id
15083: FROM okl_k_headers
15084: WHERE id = p_contract_id;
15085:
15086: CURSOR c_lap_vendor_prog_info(p_lease_app_id IN NUMBER) IS
15087: SELECT program_agreement_id

Line 15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

15245: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
15246:
15247: l_converted_amount NUMBER;
15248: l_contract_start_date DATE;
15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
15253:

Line 15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

15246:
15247: l_converted_amount NUMBER;
15248: l_contract_start_date DATE;
15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
15253:
15254: CURSOR l_asset_csr(p_chr_id IN NUMBER

Line 15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

15247: l_converted_amount NUMBER;
15248: l_contract_start_date DATE;
15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
15253:
15254: CURSOR l_asset_csr(p_chr_id IN NUMBER
15255: ,p_cle_id IN NUMBER

Line 15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

15248: l_contract_start_date DATE;
15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
15253:
15254: CURSOR l_asset_csr(p_chr_id IN NUMBER
15255: ,p_cle_id IN NUMBER
15256: ,p_book_class IN VARCHAR2 -- 7626121