259: CLOSE okc_cimv_csr;
260: RETURN(l_cimv_rec);
261: END get_cimv_rec;
262: ---------------------------------------------------------------------------
263: -- FUNCTION get_rec for: OKL_TXL_ASSETS_V
264: ---------------------------------------------------------------------------
265: FUNCTION get_talv_rec (
266: p_kle_id IN NUMBER,
267: p_trx_type IN VARCHAR2,
341: CURRENCY_CODE,
342: CURRENCY_CONVERSION_TYPE,
343: CURRENCY_CONVERSION_RATE,
344: CURRENCY_CONVERSION_DATE
345: FROM Okl_Txl_Assets_V
346: WHERE okl_txl_assets_v.kle_id = p_kle_id
347: and okl_txl_assets_v.tal_type = p_trx_type
348: and exists (select '1' from OKL_TRX_ASSETS
349: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
342: CURRENCY_CONVERSION_TYPE,
343: CURRENCY_CONVERSION_RATE,
344: CURRENCY_CONVERSION_DATE
345: FROM Okl_Txl_Assets_V
346: WHERE okl_txl_assets_v.kle_id = p_kle_id
347: and okl_txl_assets_v.tal_type = p_trx_type
348: and exists (select '1' from OKL_TRX_ASSETS
349: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
350: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
343: CURRENCY_CONVERSION_RATE,
344: CURRENCY_CONVERSION_DATE
345: FROM Okl_Txl_Assets_V
346: WHERE okl_txl_assets_v.kle_id = p_kle_id
347: and okl_txl_assets_v.tal_type = p_trx_type
348: and exists (select '1' from OKL_TRX_ASSETS
349: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
350: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
351: and OKL_TRX_ASSETS.ID = Okl_txl_assets_v.tas_id);
347: and okl_txl_assets_v.tal_type = p_trx_type
348: and exists (select '1' from OKL_TRX_ASSETS
349: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
350: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
351: and OKL_TRX_ASSETS.ID = Okl_txl_assets_v.tas_id);
352: l_talv_rec talv_rec_type;
353: BEGIN
354: x_no_data_found := TRUE;
355: -- Get current database values
5117: --sechawla : Bug# 8370324
5118: cle.start_date line_start_date,
5119: --Bug# 8652738
5120: txl.asset_key_id asset_key_id
5121: FROM OKL_TXL_ASSETS_V txl,
5122: --akrangan bug# 5362977 end
5123: --Bug# 6373605 start
5124: OKL_TRX_ASSETS tas,
5125: --Bug# 6373605 end