[Home] [Help]
690:
691: CURSOR l_contract_csr (p_ordlineid NUMBER)
692: IS
693: SELECT rel.cle_id, rel.chr_id
694: FROM okc_k_rel_objs_v rel, okc_k_lines_b line
695: WHERE rel.object1_id1 = TO_CHAR (p_ordlineid)
696: AND rel.jtot_object1_code = 'OKX_ORDERLINE'
697: AND line.ID = rel.cle_id
698: AND line.lse_id IN (9, 25);