APPS.OKL_LIKE_KIND_EXCHANGE_PVT dependencies on OKL_TXL_ASSETS_V

Line 12: FROM okl_trx_assets trx, okl_txl_assets_v txl, okl_txd_assets_v txd

8: l_total_match_amount NUMBER;
9:
10: CURSOR get_total_match_amt_csr (p_req_asset_id NUMBER, p_tax_book_code VARCHAR2) IS
11: SELECT trx.req_asset_id, sum(trx.total_match_amount)
12: FROM okl_trx_assets trx, okl_txl_assets_v txl, okl_txd_assets_v txd
13: WHERE trx.id = txl.tas_id
14: AND txl.id = txd.tal_id
15: AND trx.total_match_amount IS NOT NULL
16: AND txd.tax_book = p_tax_book_code

Line 544: l_tal_type CONSTANT OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := 'LKE';

540: -- constants
541: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_LIKE_KIND_EXCHANGE';
542: l_api_version CONSTANT NUMBER := 1.0;
543: l_tas_type CONSTANT OKL_TRX_ASSETS.TAS_TYPE%TYPE := 'LKE';
544: l_tal_type CONSTANT OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := 'LKE';
545: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
546: l_try_name CONSTANT OKL_TRX_TYPES_V.NAME%TYPE := 'Like Kind Exchange';
547: --variables
548: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;