DBA Data[Home] [Help]

APPS.OKL_LIKE_KIND_EXCHANGE_PVT dependencies on OKL_TXD_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