APPS.OKL_VP_SYNC_CR_PVT dependencies on OKC_CONTACTS

Line 688: FROM okc_contacts

684: cv_get_party_info_rec c_get_party_info_csr%ROWTYPE;
685:
686: CURSOR c_get_role_contacts_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
687: SELECT id
688: FROM okc_contacts
689: WHERE cpl_id = cp_cpl_id;
690:
691: lv_cplv_rec cplv_rec_type;
692: x_cplv_rec cplv_rec_type;

Line 938: ,okc_contacts contact

934: ,contact.cro_code
935: ,contact.jtot_object1_code contact_object
936: ,contact.id
937: FROM okc_k_party_roles_b role
938: ,okc_contacts contact
939: WHERE role.id = contact.cpl_id
940: AND role.dnz_chr_id = contact.dnz_chr_id
941: AND role.dnz_chr_id = cp_chr_id_1
942: AND NOT EXISTS(SELECT 'X'

Line 944: ,okc_contacts contact_new

940: AND role.dnz_chr_id = contact.dnz_chr_id
941: AND role.dnz_chr_id = cp_chr_id_1
942: AND NOT EXISTS(SELECT 'X'
943: FROM okc_k_party_roles_b role_new
944: ,okc_contacts contact_new
945: WHERE role_new.id = contact_new.cpl_id
946: AND role_new.chr_id = contact_new.dnz_chr_id
947: AND role_new.object1_id1 = role.object1_id1
948: AND role_new.object1_id2 = role.object1_id2