APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_LINE_STYLES_B

Line 1233: okc_line_styles_b lse

1229:
1230: SELECT lse.lty_code
1231: INTO l_lty_code
1232: FROM okc_k_lines_b cle,
1233: okc_line_styles_b lse
1234: WHERE cle.id = p_cle_id
1235: AND cle.lse_id = lse.id;
1236:
1237: IF l_lty_code = 'SO_PAYMENT' THEN

Line 1624: okc_line_styles_b lse,

1620:
1621: SELECT txl.asset_number
1622: INTO l_create_line_item_tbl(k).name
1623: FROM okc_k_lines_b cle,
1624: okc_line_styles_b lse,
1625: okl_txl_assets_b txl
1626: WHERE cle.id = txl.kle_id
1627: AND cle.lse_id = lse.id
1628: AND lse.lty_code = 'FIXED_ASSET'

Line 2771: okc_line_styles_b cls

2767: CURSOR find_model_line_id_csr (p_fin_line_id NUMBER) IS
2768: -- to find id for model line style 34 which is parent of ADD ON Line
2769: SELECT cle.id MODEL_LINE_ID
2770: FROM okc_k_lines_b cle,
2771: okc_line_styles_b cls
2772: WHERE cle.cle_id = p_fin_line_id
2773: AND cle.lse_id = cls.id
2774: AND cls.lty_code = 'ITEM';
2775: -- to find the asset_num