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 8300: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8296: WHERE vers.chr_id = p_durv_rec.chr_id;
8297:
8298: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8299: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8300: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8301: WHERE mla.id = gvr.chr_id_referred
8302: AND mla.scs_code = p_scs_code -- mla or cl
8303: AND gvr.chr_id = p_durv_rec.chr_id
8304: AND gvr.dnz_chr_id = p_durv_rec.chr_id;

Line 8964: okc_governances_v gvr

8960: p_chr_id NUMBER,
8961: p_dnz_chr_id NUMBER) IS
8962: SELECT mla.contract_number,gvr.chr_id_referred,gvr.id
8963: FROM okl_k_headers_full_v mla,
8964: okc_governances_v gvr
8965: WHERE mla.id = gvr.chr_id_referred
8966: AND mla.scs_code = p_scs_code
8967: AND gvr.dnz_chr_id = p_dnz_chr_id
8968: AND gvr.chr_id = p_chr_id;