APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_K_PROCESSES
Line 3312: FROM okc_k_processes
3308: l_error_text VARCHAR2(512);
3309:
3310: CURSOR c_pdf(cp_chr_id NUMBER) IS
3311: SELECT id, pdf_id 3312: FROM okc_k_processes 3313: WHERE chr_id = cp_chr_id
3314: AND pdf_id IN (SELECT id FROM okc_process_defs_b WHERE pdf_type = 'WPS' AND usage = 'APPROVE');
3315:
3316: l_id NUMBER;