APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_GOVERNANCES_V

Line 8374: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8370: WHERE vers.chr_id = p_durv_rec.chr_id;
8371:
8372: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8373: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8374: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8375: WHERE mla.id = gvr.chr_id_referred
8376: AND mla.scs_code = p_scs_code -- mla or cl
8377: AND gvr.chr_id = p_durv_rec.chr_id
8378: AND gvr.dnz_chr_id = p_durv_rec.chr_id;

Line 9056: okc_governances_v gvr

9052: p_chr_id NUMBER,
9053: p_dnz_chr_id NUMBER) IS
9054: SELECT mla.contract_number,gvr.chr_id_referred,gvr.id
9055: FROM okl_k_headers_full_v mla,
9056: okc_governances_v gvr
9057: WHERE mla.id = gvr.chr_id_referred
9058: AND mla.scs_code = p_scs_code
9059: AND gvr.dnz_chr_id = p_dnz_chr_id
9060: AND gvr.chr_id = p_chr_id;