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 3190: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v

3186:
3187:
3188:
3189:
3190: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
3191: -- and update the status to 'CANCELED'
3192:
3193: FOR l_assettrx_rec IN l_assettrx_csr LOOP
3194: -- update the staus (tsu_code) in okl_trx_assets_v

Line 3606: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l

3602: -- This cursor is used to get all the pending transactions for an asset. These transactions are to be cancelled
3603: -- once the asset is retired.
3604: CURSOR l_assettrx_csr(p_financial_asset_id NUMBER) IS
3605: SELECT h.id
3606: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l
3607: WHERE h.id = l.tas_id
3608: AND h.tsu_code IN ('ENTERED', 'ERROR')
3609: AND l.kle_id = p_financial_asset_id;
3610:

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

4896: -- commented call to expire_item djanaswa bug 6736148 end
4897:
4898:
4899:
4900: -- Loop thru all the pending transactions in okl_trx_assets_v and okl_txl_assets_v
4901: -- and update the status to 'CANCELED'
4902:
4903: FOR l_assettrx_rec IN l_assettrx_csr(l_kle_id) LOOP
4904: -- update the staus (tsu_code) in okl_trx_assets_v