DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_PROCESSES_V

Line 605: FROM okc_k_processes_v cps,

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

Line 1291: FROM okc_k_processes_v

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

Line 7055: FROM OKC_K_PROCESSES_V

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