APPS.OKL_AM_ASSET_DISPOSE_PVT dependencies on OKL_TXL_ASSETS_V

Line 1787: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l

1783: -- This cursor is used to get all the pending transactions for an asset. These transactions are to be calcelled
1784: -- once the asset is retired.
1785: CURSOR l_assettrx_csr IS
1786: SELECT h.id
1787: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l
1788: WHERE h.id = l.tas_id
1789: AND h.tsu_code IN ('ENTERED', 'ERROR')
1790: AND l.kle_id = p_financial_asset_id;
1791:

Line 3198: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v

3194:
3195:
3196:
3197:
3198: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
3199: -- and update the status to 'CANCELED'
3200:
3201: FOR l_assettrx_rec IN l_assettrx_csr LOOP
3202: -- update the staus (tsu_code) in okl_trx_assets_v

Line 3614: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l

3610: -- This cursor is used to get all the pending transactions for an asset. These transactions are to be cancelled
3611: -- once the asset is retired.
3612: CURSOR l_assettrx_csr(p_financial_asset_id NUMBER) IS
3613: SELECT h.id
3614: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l
3615: WHERE h.id = l.tas_id
3616: AND h.tsu_code IN ('ENTERED', 'ERROR')
3617: AND l.kle_id = p_financial_asset_id;
3618:

Line 4915: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v

4911: -- commented call to expire_item djanaswa bug 6736148 end
4912:
4913:
4914:
4915: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
4916: -- and update the status to 'CANCELED'
4917:
4918: FOR l_assettrx_rec IN l_assettrx_csr(l_kle_id) LOOP
4919: -- update the staus (tsu_code) in okl_trx_assets_v