APPS.OKL_CONTRACT_PARTY_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 690: l_dnz_chr_id okc_k_party_roles_v.dnz_chr_id%TYPE;

686:
687:
688: l_dummy_var VARCHAR2(1) := '?';
689: l_rle_code_var VARCHAR2(30) DEFAULT NULL;
690: l_dnz_chr_id okc_k_party_roles_v.dnz_chr_id%TYPE;
691:
692: CURSOR l_cpl_csr IS
693: SELECT 'x'
694: FROM OKC_CONTACTS_V

Line 704: FROM okc_k_party_roles_v

700: WHERE ID = p_cplv_rec.id;
701:
702: CURSOR cur_get_dnz_chr_id IS
703: SELECT dnz_chr_id
704: FROM okc_k_party_roles_v
705: WHERE id = p_cplv_rec.id;
706:
707: CURSOR c_party_share_exist_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
708: SELECT okl_vp_jtf_party_name_pub.get_party_name(pr.rle_code,chr.buy_or_sell,pr.object1_id1,pr.object1_id2) party_name