[Home] [Help]
1006: l_temp_sold_fee VARCHAR2(1);
1007: CURSOR sold_service_fee_csr ( p_cle_id NUMBER ) IS
1008: SELECT '1'
1009: FROM okc_k_lines_v a,
1010: okc_line_styles_v b
1011: WHERE a.lse_id = b.id
1012: AND b.lty_code = 'SOLD_SERVICE'
1013: AND a.id = p_cle_id;
1014:
1014:
1015: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1016: SELECT c.object1_id1
1017: FROM okc_k_lines_v a,
1018: okc_line_styles_v b,
1019: okc_k_items c
1020: WHERE a.lse_id = b.id
1021: AND b.lty_code = 'SOLD_SERVICE'
1022: AND a.id = p_cle_id