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 2344: okl_trx_assets ota,

2340: fin_ast_cle.name
2341: FROM okc_k_lines_v fin_ast_cle,
2342: okc_k_headers_b chr,
2343: okc_line_styles_b fin_ast_lse,
2344: okl_trx_assets ota,
2345: okl_txl_assets_b otl
2346: WHERE chr.id = p_orig_chr_id
2347: AND fin_ast_cle.chr_id = chr.id
2348: AND fin_ast_cle.dnz_chr_id = chr.id

Line 2366: okl_trx_assets ota,

2362: SELECT fin_ast_cle.id,
2363: fin_ast_cle.name
2364: FROM okl_txl_cntrct_lns tcl,
2365: okc_k_lines_v fin_ast_cle,
2366: okl_trx_assets ota,
2367: okl_txl_assets_b otl
2368: WHERE tcl.tcn_id = p_source_trx_id
2369: AND tcl.before_transfer_yn = 'N'
2370: AND fin_ast_cle.chr_id = p_orig_chr_id

Line 6649: okl_trx_assets trx,

6645: txlb.salvage_value,
6646: txlb.percent_salvage_value,
6647: txlb.id
6648: FROM okl_txl_assets_b txlb,
6649: okl_trx_assets trx,
6650: okc_k_lines_b fa_cleb,
6651: okc_line_styles_b fa_lseb
6652: WHERE txlb.kle_id = fa_cleb.id
6653: AND txlb.tal_type = 'CRL'

Line 7273: okl_trx_assets trx,

7269: CURSOR txl_asset_csr(p_chr_id IN NUMBER,
7270: p_cle_id IN NUMBER) IS
7271: SELECT txlb.id
7272: FROM okl_txl_assets_b txlb,
7273: okl_trx_assets trx,
7274: okc_k_lines_b fa_cleb,
7275: okc_line_styles_b fa_lseb
7276: WHERE txlb.kle_id = fa_cleb.id
7277: AND txlb.tal_type = 'CRL'

Line 7297: FROM okl_trx_assets trx,

7293: SELECT iti.id,
7294: iti.object_id1_new,
7295: iti.object_id2_new,
7296: iti.jtot_object_code_new
7297: FROM okl_trx_assets trx,
7298: okl_txl_itm_insts iti,
7299: okc_k_lines_b cleb_ib,
7300: okc_line_styles_b lseb_ib,
7301: okc_k_lines_b cleb_inst,