APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKL_TXL_ASSETS_V

Line 263: -- FUNCTION get_rec for: OKL_TXL_ASSETS_V

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,

Line 345: FROM Okl_Txl_Assets_V

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

Line 346: WHERE okl_txl_assets_v.kle_id = p_kle_id

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

Line 347: and okl_txl_assets_v.tal_type = p_trx_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
351: and OKL_TRX_ASSETS.ID = Okl_txl_assets_v.tas_id);

Line 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

Line 5144: FROM OKL_TXL_ASSETS_V txl,

5140: txl.tas_id sla_source_header_id,
5141: 'OKL_TXL_ASSETS_B' sla_source_line_table,
5142: tas.try_id sla_source_try_id
5143: --Bug# 6373605 end
5144: FROM OKL_TXL_ASSETS_V txl,
5145: --akrangan bug# 5362977 end
5146: --Bug# 6373605 start
5147: OKL_TRX_ASSETS tas,
5148: --Bug# 6373605 end