APPS.OKL_MLA_CREATE_UPDATE_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 363: FROM okc_k_party_roles_B

359: row_count NUMBER DEFAULT 0;
360:
361: CURSOR check_party_csr(p_chr_id NUMBER) IS
362: SELECT COUNT(1)
363: FROM okc_k_party_roles_B
364: WHERE dnz_chr_id = p_chr_id
365: AND chr_id = p_chr_id
366: AND rle_code = G_RLE_CODE
367: AND object1_id1 = p_customer_id1

Line 656: , okc_k_party_roles_b prl

652: -- cursor when only customer is selected
653: CURSOR l_source_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
654: SELECT CHR.id
655: FROM okc_k_headers_b CHR
656: , okc_k_party_roles_b prl
657: WHERE prl.dnz_chr_id = CHR.id
658: AND prl.chr_id = CHR.id
659: AND CHR.scs_code = p_scs_code
660: AND CHR.chr_type = 'CYA'

Line 673: , okc_k_party_roles_b prl

669: CURSOR l_source_chr_prog_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS
670: SELECT CHR.id
671: FROM okc_k_headers_b CHR,
672: okl_k_headers khr
673: , okc_k_party_roles_b prl
674: WHERE chr.id = khr.id
675: AND prl.dnz_chr_id = CHR.id
676: AND prl.chr_id = CHR.id
677: AND CHR.scs_code = p_scs_code