APPS.OKL_VENDOR_PROGRAM_PUB dependencies on OKC_PROCESS_DEFS_B

Line 165: l_wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE;

161:
162:
163: FUNCTION Is_Process_Active(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
164:
165: l_wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE;
166: l_item_key OKC_K_PROCESSES.PROCESS_ID%TYPE;
167: l_return_code VARCHAR2(1) := 'N';
168: l_end_date DATE;
169:

Line 173: FROM okc_process_defs_b pdfv,

169:
170: -- cursor for item type and item key
171: CURSOR l_pdfv_csr IS
172: SELECT pdfv.wf_name, cpsv.process_id
173: FROM okc_process_defs_b pdfv,
174: okc_k_processes cpsv
175: WHERE pdfv.id = cpsv.pdf_id
176: AND cpsv.chr_id = p_chr_id;
177: