APPS.OKL_VENDOR_PROGRAM_PVT dependencies on OKC_PROCESS_DEFS_B

Line 1575: l_wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE;

1571: -- An item is considered active if its end_date is NULL
1572:
1573: FUNCTION Is_Process_Active(p_chr_id IN okl_k_headers_full_v.id%TYPE) RETURN VARCHAR2 IS
1574:
1575: l_wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE;
1576: l_item_key OKC_K_PROCESSES.PROCESS_ID%TYPE;
1577: l_return_code VARCHAR2(1) := 'N';
1578: l_end_date DATE;
1579:

Line 1583: FROM okc_process_defs_b pdfv,

1579:
1580: -- cursor for item type and item key
1581: CURSOR l_pdfv_csr Is
1582: SELECT pdfv.wf_name, cpsv.process_id
1583: FROM okc_process_defs_b pdfv,
1584: okc_k_processes cpsv
1585: WHERE pdfv.id = cpsv.pdf_id
1586: AND cpsv.chr_id = p_chr_id;
1587: