APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_GOVERNANCES

Line 1169: FROM okc_governances gvr,

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

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;