DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_CHANGE_REQUESTS_B

Line 607: okc_change_requests_b crt

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:
611: BEGIN