2768: --cursor to check if financial asset appears as linked asset
2769: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
2770: SELECT cim.object1_id1 kle_id -- original asset id
2771: FROM okc_k_lines_b lnk,
2772: okc_line_styles_b lnk_lse,
2773: okc_statuses_b sts,
2774: okc_k_items cim
2775: WHERE lnk.id = cim.cle_id
2776: AND lnk.dnz_chr_id = cim.dnz_chr_id
3192: cp_fee_type IN VARCHAR2)
3193: IS
3194: SELECT '1'
3195: FROM okc_k_lines_b cle,
3196: okc_line_styles_b lse,
3197: okc_k_items cim,
3198: okc_k_lines_v clep,
3199: okc_line_styles_b lsep,
3200: OKL_K_LINES kle
3195: FROM okc_k_lines_b cle,
3196: okc_line_styles_b lse,
3197: okc_k_items cim,
3198: okc_k_lines_v clep,
3199: okc_line_styles_b lsep,
3200: OKL_K_LINES kle
3201: WHERE cle.lse_id = lse.id
3202: AND lse.lty_code = 'LINK_FEE_ASSET'
3203: AND cim.cle_id = cle.id
5031: --cursor to check if financial asset appears as linked asset
5032: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
5033: Select cim.object1_id1 kle_id -- original asset id
5034: From okc_k_lines_b lnk,
5035: okc_line_styles_b lnk_lse,
5036: okc_statuses_b sts,
5037: okc_k_items cim
5038: Where lnk.id = cim.cle_id
5039: and lnk.dnz_chr_id = cim.dnz_chr_id
6108: -- and have the correct line style
6109: CURSOR l_line_csr (cp_line_id NUMBER) IS
6110: SELECT 'Y'
6111: FROM okc_k_lines_b l,
6112: okc_line_styles_b s
6113: WHERE l.id = cp_line_id
6114: AND s.id = l.lse_id
6115: AND s.lty_code = G_FIN_ASSET_STYLE;
6116: