APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_PROCESSES_V

Line 606: FROM okc_k_processes_v cps,

602:
603: CURSOR c_locked_user(p_chr_id IN NUMBER) IS
604: SELECT cps.user_id,
605: upper(substr(cps.in_process_yn,1,1)) in_process_yn
606: FROM okc_k_processes_v cps,
607: okc_change_requests_b crt
608: WHERE crt.id = cps.crt_id
609: AND crt.chr_id = p_chr_id;
610:

Line 1292: FROM okc_k_processes_v

1288: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1289:
1290: CURSOR c_process IS
1291: SELECT id
1292: FROM okc_k_processes_v
1293: WHERE chr_id = p_from_chr_id;
1294:
1295: BEGIN
1296: x_return_status := l_return_status;

Line 7056: FROM OKC_K_PROCESSES_V

7052: ATTRIBUTE12,
7053: ATTRIBUTE13,
7054: ATTRIBUTE14,
7055: ATTRIBUTE15
7056: FROM OKC_K_PROCESSES_V
7057: WHERE ID = p_cps_id;
7058: BEGIN
7059: OPEN c_cpsv_rec;
7060: FETCH c_cpsv_rec