APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_GOVERNANCES

Line 1168: FROM okc_governances gvr,

1164: AND rgp.rgd_code NOT IN ('LATOWN','CURRENCY');
1165:
1166: CURSOR c_governances IS
1167: SELECT gvr.chr_id_referred
1168: FROM okc_governances gvr,
1169: okc_k_headers_b CHR,
1170: okc_k_headers_b mla
1171: WHERE gvr.dnz_chr_id = p_source_chr_id
1172: AND gvr.chr_id = p_source_chr_id

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;