APPS.OKS_WF_K_PROCESS_PVT dependencies on OKC_PROCESS_DEFS_B

Line 7534: FROM okc_k_processes kp, okc_process_defs_b pd

7530: l_msg_data VARCHAR2(2000);
7531:
7532: CURSOR l_pdf_csr(p_chr_id number) is
7533: SELECT pdf_id
7534: FROM okc_k_processes kp, okc_process_defs_b pd
7535: WHERE kp.chr_id=p_chr_id and kp.pdf_id=pd.id and pd.usage='APPROVE';
7536:
7537: l_contract_id NUMBER;
7538: l_pdf_id NUMBER;

Line 8563: OKC_PROCESS_DEFS_B KPDF

8559: --no active approval workflow exists
8560: AND NOT EXISTS
8561: (SELECT 1
8562: FROM WF_ITEMS WF,
8563: OKC_PROCESS_DEFS_B KPDF
8564: WHERE WF.item_key = okck.contract_number || okck.contract_number_modifier
8565: AND WF.end_date IS NULL
8566: AND WF.item_type = KPDF.wf_name
8567: AND KPDF.pdf_type = 'WPS')