APPS.OKL_RELEASE_PVT dependencies on OKL_TRX_ASSETS

Line 60: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;

56: INDEX BY BINARY_INTEGER;
57: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.CLEV_REC_TYPE;
58: subtype klev_tbl_type is OKL_CONTRACT_PUB.klev_tbl_type;
59: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
60: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
61: -------------------------------------------------------------------------------------------------
62: ------------------------------------------------------------------------------
63: --Start of comments
64: --

Line 459: FROM OKL_TRX_ASSETS

455: TRANS_NUMBER,
456: COMMENTS,
457: REQ_ASSET_ID,
458: TOTAL_MATCH_AMOUNT
459: FROM OKL_TRX_ASSETS
460: WHERE id = p_tas_id;
461: BEGIN
462: OPEN c_trxv_rec(p_tas_id);
463: FETCH c_trxv_rec INTO

Line 2368: okl_trx_assets ota,

2364: fin_ast_cle.name
2365: FROM okc_k_lines_v fin_ast_cle,
2366: okc_k_headers_b chr,
2367: okc_line_styles_b fin_ast_lse,
2368: okl_trx_assets ota,
2369: okl_txl_assets_b otl
2370: WHERE chr.id = p_orig_chr_id
2371: AND fin_ast_cle.chr_id = chr.id
2372: AND fin_ast_cle.dnz_chr_id = chr.id

Line 2390: okl_trx_assets ota,

2386: SELECT fin_ast_cle.id,
2387: fin_ast_cle.name
2388: FROM okl_txl_cntrct_lns tcl,
2389: okc_k_lines_v fin_ast_cle,
2390: okl_trx_assets ota,
2391: okl_txl_assets_b otl
2392: WHERE tcl.tcn_id = p_source_trx_id
2393: AND tcl.before_transfer_yn = 'N'
2394: AND fin_ast_cle.chr_id = p_orig_chr_id

Line 6958: okl_trx_assets trx,

6954: txlb.salvage_value,
6955: txlb.percent_salvage_value,
6956: txlb.id
6957: FROM okl_txl_assets_b txlb,
6958: okl_trx_assets trx,
6959: okc_k_lines_b fa_cleb,
6960: okc_line_styles_b fa_lseb
6961: WHERE txlb.kle_id = fa_cleb.id
6962: AND txlb.tal_type = 'CRL'

Line 7593: okl_trx_assets trx,

7589: CURSOR txl_asset_csr(p_chr_id IN NUMBER,
7590: p_cle_id IN NUMBER) IS
7591: SELECT txlb.id
7592: FROM okl_txl_assets_b txlb,
7593: okl_trx_assets trx,
7594: okc_k_lines_b fa_cleb,
7595: okc_line_styles_b fa_lseb
7596: WHERE txlb.kle_id = fa_cleb.id
7597: AND txlb.tal_type = 'CRL'

Line 7617: FROM okl_trx_assets trx,

7613: SELECT iti.id,
7614: iti.object_id1_new,
7615: iti.object_id2_new,
7616: iti.jtot_object_code_new
7617: FROM okl_trx_assets trx,
7618: okl_txl_itm_insts iti,
7619: okc_k_lines_b cleb_ib,
7620: okc_line_styles_b lseb_ib,
7621: okc_k_lines_b cleb_inst,