DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_K_PROCESSES

Line 3301: FROM okc_k_processes

3297: l_error_text VARCHAR2(512);
3298:
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;