DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_COMP_PVT dependencies on OKC_K_LINES_B

Line 783: ,okc_k_lines_b cleb

779: ,cleb.id cle_id
780: ,trxa.date_trans_occurred
781: FROM okl_trx_assets trxa
782: ,okl_txl_assets_b txla
783: ,okc_k_lines_b cleb
784: ,okc_line_styles_b lseb
785: WHERE txla.kle_id = cleb.id
786: AND cleb.lse_id = lseb.id
787: AND lseb.lty_code = 'FIXED_ASSET'

Line 1250: FROM okc_k_lines_b cle,

1246: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1247:
1248: CURSOR fin_ast_csr (p_tal_id IN NUMBER) IS
1249: SELECT cle.cle_id
1250: FROM okc_k_lines_b cle,
1251: okl_txl_assets_b tal
1252: WHERE cle.id = tal.kle_id
1253: AND tal.id = p_tal_id;
1254:

Line 1255: l_cle_id okc_k_lines_b.id%TYPE;

1251: okl_txl_assets_b tal
1252: WHERE cle.id = tal.kle_id
1253: AND tal.id = p_tal_id;
1254:
1255: l_cle_id okc_k_lines_b.id%TYPE;
1256: l_cle_tbl okl_split_asset_pub.cle_tbl_type;
1257:
1258: /*
1259: -- mvasudev, 08/24/2004

Line 1271: ,okc_k_lines_b cleb

1267: ,cleb.cle_id cle_id
1268: ,trxa.date_trans_occurred
1269: FROM okl_trx_assets trxa
1270: ,okl_txl_assets_b txla
1271: ,okc_k_lines_b cleb
1272: ,okc_line_styles_b lseb
1273: WHERE txla.kle_id = cleb.id
1274: AND cleb.lse_id = lseb.id
1275: AND lseb.lty_code = 'FIXED_ASSET'