APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_PROCESS_DEFS_B

Line 3303: AND pdf_id IN (SELECT id FROM okc_process_defs_b WHERE pdf_type = 'WPS' AND usage = 'APPROVE');

3299: CURSOR c_pdf(cp_chr_id NUMBER) IS
3300: SELECT id, pdf_id
3301: FROM okc_k_processes
3302: WHERE chr_id = cp_chr_id
3303: AND pdf_id IN (SELECT id FROM okc_process_defs_b WHERE pdf_type = 'WPS' AND usage = 'APPROVE');
3304:
3305: l_id NUMBER;
3306: l_pdf_id NUMBER;
3307: l_cpsv_rec_in OKC_CPS_PVT.cpsv_rec_type;