APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_GOVERNANCES_V

Line 8096: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8092: WHERE vers.chr_id = p_durv_rec.chr_id;
8093:
8094: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8095: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8096: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8097: WHERE mla.id = gvr.chr_id_referred
8098: AND mla.scs_code = p_scs_code -- mla or cl
8099: AND gvr.chr_id = p_durv_rec.chr_id
8100: AND gvr.dnz_chr_id = p_durv_rec.chr_id;