APPS.OKC_CONTRACT_PVT dependencies on OKC_PROCESS_DEFS_B

Line 76: l_wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE;

72: -- An item is considered active if its end_date is NULL
73: --
74: FUNCTION Is_Process_Active(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
75:
76: l_wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE;
77: l_item_key OKC_K_PROCESSES.PROCESS_ID%TYPE;
78: l_return_code VARCHAR2(1) := 'N';
79: l_end_date DATE;
80:

Line 84: FROM okc_process_defs_b pdfv,

80:
81: -- cursor for item type and item key
82: Cursor l_pdfv_csr Is
83: SELECT pdfv.wf_name, cpsv.process_id
84: FROM okc_process_defs_b pdfv,
85: okc_k_processes cpsv
86: WHERE pdfv.id = cpsv.pdf_id
87: AND cpsv.chr_id = p_chr_id;
88: