[Home] [Help]
2902:
2903: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
2904: p_line_id okc_k_lines_b.id%TYPE) IS
2905: SELECT rlobj.object1_id1
2906: FROM okc_k_rel_objs_v rlobj
2907: WHERE rlobj.chr_id = p_chr_id
2908: AND rlobj.cle_id = p_line_id
2909: AND rlobj.rty_code = 'OKLSRV'
2910: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';