APPS.OKS_WF_K_PROCESS_PVT dependencies on OKC_PROCESS_DEFS_B

Line 7838: FROM okc_k_processes kp, okc_process_defs_b pd

7834: l_msg_data VARCHAR2(2000);
7835:
7836: CURSOR l_pdf_csr(p_chr_id number) is
7837: SELECT pdf_id
7838: FROM okc_k_processes kp, okc_process_defs_b pd
7839: WHERE kp.chr_id=p_chr_id and kp.pdf_id=pd.id and pd.usage='APPROVE';
7840:
7841: l_contract_id NUMBER;
7842: l_pdf_id NUMBER;

Line 8867: OKC_PROCESS_DEFS_B KPDF

8863: --no active approval workflow exists
8864: AND NOT EXISTS
8865: (SELECT 1
8866: FROM WF_ITEMS WF,
8867: OKC_PROCESS_DEFS_B KPDF
8868: WHERE WF.item_key = okck.contract_number || okck.contract_number_modifier
8869: AND WF.end_date IS NULL
8870: AND WF.item_type = KPDF.wf_name
8871: AND KPDF.pdf_type = 'WPS')