[Home] [Help]
1377:
1378: CURSOR sold_service_fee_csr ( p_cle_id NUMBER ) IS
1379: SELECT '1'
1380: FROM okc_k_lines_v a,
1381: okc_line_styles_v b
1382: WHERE a.lse_id = b.id
1383: AND b.lty_code = 'SOLD_SERVICE'
1384: AND a.id = p_cle_id;
1385:
1385:
1386: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1387: SELECT c.object1_id1
1388: FROM okc_k_lines_v a,
1389: okc_line_styles_v b,
1390: okc_k_items c
1391: WHERE a.lse_id = b.id
1392: AND b.lty_code = 'SOLD_SERVICE'
1393: AND a.id = p_cle_id