APPS.OKL_LA_TRADEIN_PVT dependencies on OKC_K_LINES_B

Line 42: FROM okc_k_lines_b

38: line_number NUMBER;
39: -- cursor to retrieve the chr_id( contract id) to set the org
40: CURSOR find_chr_id_csr(p_line_id NUMBER) IS
41: SELECT dnz_chr_id chr_id
42: FROM okc_k_lines_b
43: WHERE id = p_line_id;
44:
45: BEGIN
46:

Line 312: FROM okc_k_lines_b cle,

308: l_create_line_item_tbl(k).capital_amount := l_assoc_amount;
309:
310: SELECT txl.asset_number
311: INTO l_create_line_item_tbl(k).name
312: FROM okc_k_lines_b cle,
313: okc_line_styles_b lse,
314: okl_txl_assets_b txl
315: WHERE cle.id = txl.kle_id
316: AND cle.lse_id = lse.id

Line 340: FROM okc_k_lines_b cle,

336: l_update_line_item_tbl(m).capital_amount := l_assoc_amount;
337:
338: SELECT txl.asset_number
339: INTO l_update_line_item_tbl(m).name
340: FROM okc_k_lines_b cle,
341: okc_line_styles_b lse,
342: okl_txl_assets_b txl
343: WHERE cle.id = txl.kle_id
344: AND cle.lse_id = lse.id

Line 439: FROM okc_k_lines_b cle,

435: l_program_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'allocate_amount';
436:
437: CURSOR c_sublines IS
438: SELECT cle.id
439: FROM okc_k_lines_b cle,
440: okc_line_styles_b lse
441: WHERE cle.cle_id = p_cle_id
442: AND cle.lse_id = lse.id
443: AND lse.lty_code = 'LINK_FEE_ASSET';

Line 449: okc_k_lines_b cle,

445: CURSOR c_assets IS
446: SELECT cle.cle_id fin_asset_id,
447: txl.asset_number
448: FROM okl_txl_assets_b txl,
449: okc_k_lines_b cle,
450: okc_line_styles_b lse
451: WHERE cle.dnz_chr_id = p_chr_id
452: AND cle.id = txl.kle_id
453: AND cle.lse_id = lse.id

Line 1524: okc_k_lines_b cle,

1520: CURSOR c_assets IS
1521: SELECT cle.cle_id fin_asset_id,
1522: txl.asset_number
1523: FROM okl_txl_assets_b txl,
1524: okc_k_lines_b cle,
1525: okc_line_styles_b lse
1526: WHERE cle.dnz_chr_id = p_chr_id
1527: AND cle.id = txl.kle_id
1528: AND cle.lse_id = lse.id