1214: l_temp_sold_fee VARCHAR2(1);
1215: CURSOR sold_service_fee_csr ( p_cle_id NUMBER ) IS
1216: SELECT '1'
1217: FROM okc_k_lines_v a,
1218: okc_line_styles_v b
1219: WHERE a.lse_id = b.id
1220: AND b.lty_code = 'SOLD_SERVICE'
1221: AND a.id = p_cle_id;
1222:
1222:
1223: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1224: SELECT c.object1_id1
1225: FROM okc_k_lines_v a,
1226: okc_line_styles_v b,
1227: okc_k_items c
1228: WHERE a.lse_id = b.id
1229: AND b.lty_code = 'SOLD_SERVICE'
1230: AND a.id = p_cle_id