APPS.OKC_CHANGE_REQUEST_PVT dependencies on OKC_K_HDR_AGREEDS_V

Line 203: from OKC_K_HDR_AGREEDS_V

199: where id = p_crtv_rec.id;
200:
201: cursor key_csr is
202: select substr(CONTRACT_NUMBER||CONTRACT_NUMBER_MODIFIER||l_crtv_rec.NAME,1,240) key
203: from OKC_K_HDR_AGREEDS_V
204: where ID = l_crtv_rec.chr_id;
205: --
206: cursor approval_active_csr is
207: select item_type

Line 386: OKC_K_HDR_AGREEDS_V K

382: select C.crs_code,
383: substr(K.CONTRACT_NUMBER||K.CONTRACT_NUMBER_MODIFIER||C.NAME,1,240) key
384: from
385: OKC_CHANGE_REQUESTS_V C,
386: OKC_K_HDR_AGREEDS_V K
387: where C.ID = p_corv_rec.CRT_ID
388: and K.ID = C.chr_id;
389: --
390: cursor approval_active_csr is