APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_GOVERNANCES_V

Line 8105: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8101: WHERE vers.chr_id = p_durv_rec.chr_id;
8102:
8103: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8104: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8105: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8106: WHERE mla.id = gvr.chr_id_referred
8107: AND mla.scs_code = p_scs_code -- mla or cl
8108: AND gvr.chr_id = p_durv_rec.chr_id
8109: AND gvr.dnz_chr_id = p_durv_rec.chr_id;