APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_LINE_STYLES_B

Line 1228: okc_line_styles_b lse

1224:
1225: SELECT lse.lty_code
1226: INTO l_lty_code
1227: FROM okc_k_lines_b cle,
1228: okc_line_styles_b lse
1229: WHERE cle.id = p_cle_id
1230: AND cle.lse_id = lse.id;
1231:
1232: IF l_lty_code = 'SO_PAYMENT' THEN

Line 1620: okc_line_styles_b lse,

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

Line 2733: okc_line_styles_b cls

2729: CURSOR find_model_line_id_csr (p_fin_line_id NUMBER) IS
2730: -- to find id for model line style 34 which is parent of ADD ON Line
2731: SELECT cle.id MODEL_LINE_ID
2732: FROM okc_k_lines_b cle,
2733: okc_line_styles_b cls
2734: WHERE cle.cle_id = p_fin_line_id
2735: AND cle.lse_id = cls.id
2736: AND cls.lty_code = 'ITEM';
2737: -- to find the asset_num