APPS.OKL_ACCOUNTING_PROCESS_PVT dependencies on OKL_TXL_ASSETS_B

Line 188: FROM OKL_TXL_ASSETS_B tal,

184:
185: CURSOR tal_csr(v_source_id NUMBER) IS
186: SELECT tas.trans_number,
187: try.trx_type_class
188: FROM OKL_TXL_ASSETS_B tal,
189: OKL_TRX_ASSETS tas,
190: OKL_TRX_TYPES_V try
191: WHERE tal.id = v_source_id
192: AND tal.tas_id = tas.id

Line 266: ELSIF (dists_rec.source_table = 'OKL_TXL_ASSETS_B') THEN

262: END IF;
263:
264: CLOSE trx_csr;
265:
266: ELSIF (dists_rec.source_table = 'OKL_TXL_ASSETS_B') THEN
267:
268: OPEN tal_csr(dists_rec.source_id);
269: FETCH tal_csr INTO l_trx_number,
270: l_trx_type_class;

Line 669: okl_txl_assets_b txl,

665: CURSOR trx_asset_csr (p_source_id NUMBER) IS
666: SELECT
667: tas.try_id
668: FROM
669: okl_txl_assets_b txl,
670: okl_trx_assets tas
671: WHERE
672: txl.id = p_source_id AND
673: txl.tas_id = tas.id;

Line 723: ELSIF dist_rec.source_table = 'OKL_TXL_ASSETS_B' THEN

719: IF dist_rec.source_table = 'OKL_TXL_CNTRCT_LNS' THEN
720: FOR trx_cntrct_rec IN trx_cntrct_csr (dist_rec.source_id) LOOP
721: l_aelv_tbl_in(i).REFERENCE3 := trx_cntrct_rec.try_id;
722: END LOOP;
723: ELSIF dist_rec.source_table = 'OKL_TXL_ASSETS_B' THEN
724: FOR trx_asset_rec IN trx_asset_csr (dist_rec.source_id) LOOP
725: l_aelv_tbl_in(i).REFERENCE3 := trx_asset_rec.try_id;
726: END LOOP;
727: END IF;

Line 1095: okl_txl_assets_b tal

1091: FROM okl_Ae_headers aeh,
1092: okl_ae_lines ael,
1093: okl_trx_types_v try,
1094: okl_trx_assets tas,
1095: okl_txl_assets_b tal
1096: WHERE aeh.ae_header_id=ael.ae_header_id
1097: AND aeh.accounting_error_code IS NULL
1098: AND ael.accounting_error_code IS NULL
1099: AND aeh.request_id = p_request_id

Line 1193: okl_txl_assets_b tal,

1189: tal.currency_code currency_code,
1190: tal.original_cost amount,
1191: tas.date_trans_occurred transaction_date
1192: FROM
1193: okl_txl_assets_b tal,
1194: okl_trx_assets tas,
1195: okl_trx_types_v try,
1196: okc_k_headers_b khr
1197: WHERE