494: cp_khr_id NUMBER,
495: cp_qpt_code VARCHAR2) IS
496: SELECT kh.buy_or_sell k_buy_or_sell,
497: lq.meaning qp_party_role
498: FROM okc_k_headers_v kh,
499: fnd_lookups lq
500: WHERE kh.id = cp_khr_id
501: AND lq.lookup_code = cp_qpt_code
502: AND lq.lookup_type = 'OKL_QUOTE_PARTY_TYPE';