[Home] [Help]
1861: --SECHAWLA 10-FEB-06 5016156 : begin
1862: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2) IS
1863: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
1864: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
1865: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
1866: WHERE h.id = l.tas_id
1867: AND h.date_trans_occurred <= cp_trx_date
1868: AND h.tas_type in ('AMT','AUD','AUS')
1869: AND l.asset_number = cp_asset_number;
3264: l_fxhv_rec.khr_id := lx_tlpv_rec.dnz_khr_id;
3265: l_fxhv_rec.try_id := lx_thpv_rec.try_id;
3266: -- line record
3267: l_fxlv_rec.source_id := lx_tlpv_rec.id;
3268: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';
3269: l_fxlv_rec.kle_id := p_financial_asset_id;
3270: l_fxlv_rec.asset_id := lx_tlpv_rec.dnz_asset_id;
3271: l_fxlv_rec.fa_transaction_id := g_trans_id_tbl(i);
3272: l_fxlv_rec.asset_book_type_name := lx_tlpv_rec.corporate_book;
3674: --SECHAWLA 10-FEB-06 5016156
3675: CURSOR l_offlseassettrx_csr(cp_trx_date IN DATE, cp_asset_number IN VARCHAR2) IS
3676: SELECT h.tsu_code, h.tas_type, h.date_trans_occurred, l.dnz_asset_id,
3677: l.asset_number, l.kle_id ,l.DNZ_KHR_ID
3678: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l
3679: WHERE h.id = l.tas_id
3680: AND h.date_trans_occurred <= cp_trx_date
3681: AND h.tas_type in ('AMT','AUD','AUS')
3682: AND l.asset_number = cp_asset_number;
4970: l_fxhv_rec.khr_id := lx_tlpv_rec.dnz_khr_id;
4971: l_fxhv_rec.try_id := lx_thpv_rec.try_id;
4972: -- line record
4973: l_fxlv_rec.source_id := lx_tlpv_rec.id;
4974: l_fxlv_rec.source_table := 'OKL_TXL_ASSETS_B';
4975: l_fxlv_rec.kle_id := lx_tlpv_rec.kle_id;
4976: l_fxlv_rec.asset_id := lx_tlpv_rec.dnz_asset_id;
4977: l_fxlv_rec.fa_transaction_id := g_trans_id_tbl(i);
4978: l_fxlv_rec.asset_book_type_name := lx_tlpv_rec.corporate_book;