APPS.OKL_AM_CALCULATE_QUOTE_PVT dependencies on OKC_LINE_STYLES_B

Line 2819: okc_line_styles_b lnk_lse,

2815: --cursor to check if financial asset appears as linked asset
2816: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
2817: SELECT cim.object1_id1 kle_id -- original asset id
2818: FROM okc_k_lines_b lnk,
2819: okc_line_styles_b lnk_lse,
2820: okc_statuses_b sts,
2821: okc_k_items cim
2822: WHERE lnk.id = cim.cle_id
2823: AND lnk.dnz_chr_id = cim.dnz_chr_id

Line 3243: okc_line_styles_b lse,

3239: cp_fee_type IN VARCHAR2)
3240: IS
3241: SELECT '1'
3242: FROM okc_k_lines_b cle,
3243: okc_line_styles_b lse,
3244: okc_k_items cim,
3245: okc_k_lines_v clep,
3246: okc_line_styles_b lsep,
3247: OKL_K_LINES kle

Line 3246: okc_line_styles_b lsep,

3242: FROM okc_k_lines_b cle,
3243: okc_line_styles_b lse,
3244: okc_k_items cim,
3245: okc_k_lines_v clep,
3246: okc_line_styles_b lsep,
3247: OKL_K_LINES kle
3248: WHERE cle.lse_id = lse.id
3249: AND lse.lty_code = 'LINK_FEE_ASSET'
3250: AND cim.cle_id = cle.id

Line 5154: okc_line_styles_b lnk_lse,

5150: --cursor to check if financial asset appears as linked asset
5151: CURSOR l_lnk_ast_csr (p_link_line_id OKC_K_LINES_B.ID%TYPE) IS
5152: Select cim.object1_id1 kle_id -- original asset id
5153: From okc_k_lines_b lnk,
5154: okc_line_styles_b lnk_lse,
5155: okc_statuses_b sts,
5156: okc_k_items cim
5157: Where lnk.id = cim.cle_id
5158: and lnk.dnz_chr_id = cim.dnz_chr_id

Line 6231: okc_line_styles_b s

6227: -- and have the correct line style
6228: CURSOR l_line_csr (cp_line_id NUMBER) IS
6229: SELECT 'Y'
6230: FROM okc_k_lines_b l,
6231: okc_line_styles_b s
6232: WHERE l.id = cp_line_id
6233: AND s.id = l.lse_id
6234: AND s.lty_code = G_FIN_ASSET_STYLE;
6235: